Compare two tables

  • Thread starter Thread starter David Peterson
  • Start date Start date
D

David Peterson

I have two tables with the same structure in 2 different databases.

How can I compare every field of every record to make sure the tables
contain identical data?
 
Hi,

There are third party tools for that, or, home maid, you can link to the table from the other
database into the first one, and run the unmatched query wizard. That wizard allows only ONE field
to be established as a match, but edit the query in the designer, and add the same outer join than
the one already drawn by the wizard, for the other fields (the criteria do not need any change).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top