Merging Data from Several Database's into One

T

Tammy

Is there an easy way to merge several (8 or so) into one database? I know
you can copy and past with the option of merging the data only but each of
these 8 databases have 40 tables each. It would take FOREVER to copy and
past 40 tables in 8 databases. There has GOT to be an easier way to merge
the data only. Any help would be GREATLY appreciated.
 
V

Van T. Dinh

You can create a Union Query to combine data from 8 different Tables and
then use this Query as the Source for a Make-Table Query to create the Table
with combined data.

You will need to do the above 40 times, one for each Table in the source
databases.

Check Access Help on Union Query and Make-Table Query.
 
Top