Compare two tables

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

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I compare data in two tables 7
acnewrec? 1
New to Access 2003 - Matching Text 3
Open two access databases simultaneoulsy 2
join 3 tables 0
Access Sequentially numbered column that resets with each new sample 0
Detect missing records 11
compare data in identical tables 2

Top