How to compare tables on different databases (1 Viewer)

[seamusnboo]

Hi, I need an advice here. We have a database we use at work to register the feeding of animals in a park everyday. Somehow, one of the persons who's assigned to enter the data found an old version of the database and started entering data in it, instead of entering the data on the right database. This old database had some data in it already so now it's hard to know what data is new and what data is old.

Isn't there any way I can compare these tables from both old and new databases and see which data match and witch don't so I can get this new data from the old database and transfer them to the correct one?

 

[Groundrush]

Use the "Find Duplicate Query Wizard" & "Find Unmatched Query Wiizard"

You may need to import the duplicate tables from the two db's into a test db
rename them to tblOld and tblNew & run the above qry's.

That should highlight the old and the new data..