Tables

M

Marcello

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?
 
R

Rick Brandt

Marcello said:
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?
Click to expand...

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.
 
M

Marcello

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

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.
 
J

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.
Click to expand...

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]
 
Top