combining two databases 1

[SNicholls]

Someone erroneously entered data into an older version of a database. I need to bring all that data into the current database.
The database has 10 tables - the main table + 7 "lookup" tables (two of which permit adding if the choice isn't there) + 2 join tables. Five of the lookup tables and the 2 join tables will be identical in both databases.

What's the best way to get the data from the old database into the new one?

Thank you.

SNicholls

 

[HitechUser]

SNicholls

If the changes are "adds" (no updates). Then create a link to the old MDB (from your current MDB). Now using the query tool create an Append query to add the records (from the linked table) to your current table.

Follow this procedure for each table.

Then delete your links.