Merging databases

[Patrick]

I currently have data in four seperate databases. The table names are all the
same, but the data is different. I want to merge these four databases into
one large database with all the data intact. The tables in question are named
'Invoice_Summary', ;Invoice_Detail', and 'Invoice_File' in each of the
databases so I'd like the new database to have these three tables with all
the info from each of the smaller databases. How do I go about doing this?

 

[Jeff Boyce]

Patrick

Backup, backup, backup!

OK, now you can start...

Open one of them that will get turned into the combined/merged db (or create
a new empty one).

Link to the tables in each of the four. You might make it easier on
yourself by renaming the tables from each (whatever works for you, perhaps
something like "db1_Invoice_Summary", "db2_Invoice ...").

Now, do you care which of the four dbs the record comes from, or do you just
want the records in one big pile? If the former, you'll need to add a field
to your table to hold the source (e.g., "db1", "db2", ...). If the latter,
do you have a primary key, and what happens to related records if you use
the same primary key value in more than one db?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Klatuu]

If you have any autonumber fields, particularly those used correctly to
relate child tables, it is no problem. All you need to do is link to the
tables in the other databases and run an append query to pull the data in.