How to migrate data to new db ?

[tmb]

I have an Access db with some data in it.

I have a copy of the data base with no data in it... only the empty tables,
etc.

Is there an easyway to migrate the data from the old db to the new? Or to
import it into the new from the old?

thanks

 

[Guest]

Open your emtpy .mdb and have a look at:
File ---> Get External Data ---> Import

Jarrod

 

[John Vinson]

I have an Access db with some data in it.

I have a copy of the data base with no data in it... only the empty tables,
etc.

Is there an easyway to migrate the data from the old db to the new? Or to
import it into the new from the old?

thanks

1. Open the target database
2. Select File... Get External Data... Import
3. Select each table in turn, and choose the option to append to an
existing table

You may need to do this in a particular order ("lookup" tables first,
then "one" side tables, then "many" side tables) if you've enforced
referential integrity.

Alternatively, use File... Get External Data... Link and link to all
the tables. Access will suffix each linked table with a number
(usually 1) if this would cause duplicate table names. Then run Append
queries to append the data.

Or... just delete all the empty tables, and import all the data
tables!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps