Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafemuddy

Post to this Thread - Sort Descending - Printer Friendly - Home


Tech: Moving Access database to new platform

Wolfhound person 21 Jul 09 - 04:43 AM
Mick Pearce (MCP) 21 Jul 09 - 05:30 AM
treewind 21 Jul 09 - 05:42 AM
GUEST,Russ 21 Jul 09 - 06:21 AM
Mick Pearce (MCP) 21 Jul 09 - 07:23 AM
GUEST,Chris Brady 21 Jul 09 - 08:02 AM
Share Thread
more
Lyrics & Knowledge Search [Advanced]
DT  Forum
Sort (Forum) by:relevance date
DT Lyrics:




Subject: Tech: Moving Access database to new platform
From: Wolfhound person
Date: 21 Jul 09 - 04:43 AM

Can anybody explain to me how to shift an entire database, currently in Access on XP, on to a different database program, preferably in Open Office or something flexible.

I don't want to have to re-enter 800 entries each with 20 odd fields

I gather Access is on its way out, and anyway it is not readable on Mac or non-Microsoft machines.

Plain English preferred: a little geek-speak acceptable.

Thanks

Paws


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Moving Access database to new platform
From: Mick Pearce (MCP)
Date: 21 Jul 09 - 05:30 AM

From memory, if you're using Open Office, you can link to access tables from OO (ie make it look as if the table is part of your OO database; it's a built-in feature of OO). Then you can copy to a native table.

Mick


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Moving Access database to new platform
From: treewind
Date: 21 Jul 09 - 05:42 AM

MCP's probably right.

If that doesn't work, there's usually a way of exporting/importing data via CSV files - nearly everything can deal with those.

Anahata


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Moving Access database to new platform
From: GUEST,Russ
Date: 21 Jul 09 - 06:21 AM

Exporting the data won't be a problem.

Right click on a table and select "Export."
In the "Save as type" dropdown select "Text Files..."
This will open the Text Export Wizard.
Select "Delimited", Next
Select "Comma", Next
Select "Finish"

Unfortunately you cannot export Queries, Forms, Reports, Web Pages, Macros, and Modules as such.
If, for example, you export a query you will export the data returned by the query.
Depending upon where the data will eventually reside you can save the query's SQL code.

I don't think Access will be disappearing any time soon.
MS will be including it in their Office 2010 suite.


Russ (Permanent GUEST)


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Moving Access database to new platform
From: Mick Pearce (MCP)
Date: 21 Jul 09 - 07:23 AM

Here's the OO wiki info on connecting to Access: Connecting To Microsoft Access.

I have done this some time ago, and I seem to recall that it was fairly trivial to do (I haven't OO on my machine at the moment, so I can't check it).

Mick


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Moving Access database to new platform
From: GUEST,Chris Brady
Date: 21 Jul 09 - 08:02 AM

Just an additional tip - if exporting to CSV files don't use comma ',' as a delimiter if any text data has a comma (or more) embedded in it. Use a delimiter that is unlikely to be in any text data such as hash '#' or at '@'


Post - Top - Home - Printer Friendly - Translate
  Share Thread:
More...

Reply to Thread
Subject:  Help
From:
Preview   Automatic Linebreaks   Make a link ("blue clicky")


Mudcat time: 21 February 12:37 PM EST

[ Home ]

All original material is copyright © 1998 by the Mudcat Café Music Foundation, Inc. All photos, music, images, etc. are copyright © by their rightful owners. Every effort is taken to attribute appropriate copyright to images, content, music, etc. We are not a copyright resource.