View Full Version : Merge Tables


Ganley
05-02-2007, 01:46 AM
I have database A & database B, which is a copy of the first.
I have made some changes to database B but need to merge one table back into the original database.

Any ideas.

Thanks.

ColinEssex
05-02-2007, 02:34 AM
Link to tableB from databaseA and do a makeTable query to replace tableA in databaseA.

Ensure the fields are the same etc

Col

Ron_dK
05-02-2007, 03:37 AM
I have made some changes to database B but need to merge one table back into the original database.


Simple method :

Go to Dbase A and delete table1.
While in Dbase A , go to File > get external data > import and import table1 from Dbase B.

Hth