Merge Tables

[Ganley]

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]

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]

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