Tables

[Guest]

I have 4 diffrent access files and I want to merge similar tables from those
four databases into one table what is the best way to do that?

 

[Rick Brandt]

I have 4 diffrent access files and I want to merge similar tables
from those four databases into one table what is the best way to do
that?

Link to the tables in the other three files in the fourth file and then run
append queries to copy the data form the linked tables into the non-linked
table. The links can be deleted afterwards.

 

[Joseph Meehan]

I have 4 diffrent access files and I want to merge similar tables from
those four databases into one table what is the best way to do that?

How similar? or more important How un-simular?

 

[Guest]

All four data bases are exactly the same tables and everything just the
filenames are diffrent

 

[Joseph Meehan]

All four data bases are exactly the same tables and everything just
the filenames are diffrent

Link to each one and use an append query to add to the domestic table.
(you can make a new domestic table in a new database if you like by
importing one of the tables.

 

[LeeLi]

you have to export out all the 4 tables data out first and import back to
the one table. of course, yr tables fields for the 4 databases must
standardize first before you perform the export and import.

 

[John Vinson]

you have to export out all the 4 tables data out first and import back to
the one table. of course, yr tables fields for the 4 databases must
standardize first before you perform the export and import.

It's actually not necessary to export the tables. Instead, you can use
File... Get External Data... Link to connect to the tables in another
database, and then run an Append query to append the data to the local
table.

This kind of merge can cause many problems, however, especially if the
tables contain Autonumber primary keys which are linked to other
tables in the database; there will almost certainly be cases where a
single autonumber value occurs in two (or all four) tables. It will
probably be necessary to resolve these duplicates before the data can
be successfully combined.

John W. Vinson[MVP]