Merging Identical Access Databases into One

[Clayton]

I have several identical copies of an Access database,
each containing different data. I want to be able to take
all of these seperate databases and merge them together
without having to do it manually, one table at a time.
Because the design structure of these databases is
identical, I think it should be possible to simply merge
the data from these sources into one database location.
Any help on this subject would be greatly appreciated.
Thank you in advance.

Clayton

 

[mae]

copy all the tables from different databases
then create a make table query of all the tables

 

[John Vinson]

I have several identical copies of an Access database,
each containing different data. I want to be able to take
all of these seperate databases and merge them together
without having to do it manually, one table at a time.
Because the design structure of these databases is
identical, I think it should be possible to simply merge
the data from these sources into one database location.
Any help on this subject would be greatly appreciated.
Thank you in advance.

Clayton

This job can range from tedious to monstrously difficult. The latter
arises if there are Autonumber primary keys in any of the tables - the
independent databases will have conflicting values for these
autonumbers, and you'll also have to deal with the possibility that
the same entity is represented two or more times in different
databases. Identifying the duplicates can be a major hassle.

There is certainly no one-shot merge. You'll need to link to the
tables, resolve any duplicate data or duplicate ID problems, and run
append queries. I wish there were a better answer!