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.

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.

--
HTH
Van T. Dinh
MVP (Access)


"Tammy" <(E-Mail Removed)> wrote in message
news:C5398E0F-5148-4E26-969B-(E-Mail Removed)...
> 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.

3r2r
"Tammy" <(E-Mail Removed)> wrote in message
news:C5398E0F-5148-4E26-969B-(E-Mail Removed)...
> 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.