Comparing two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I compare two identically structured tables an flag the entries that are not identical (any change in any field)?

I had a "screw-up" witht the database and want to compare the current table information to a backup copy.

Thanks

Daniel
 
I make a query of each table, then combine them in a UNION ALL query using
TOTALS and COUNT on the Primary key.

Any entry that has a one count is NOT identical.

ed

Daniel said:
How can I compare two identically structured tables an flag the entries
Click to expand...
that are not identical (any change in any field)?
I had a "screw-up" witht the database and want to compare the current
Click to expand...
table information to a backup copy.
 

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

Comparing fields from 2 similar tables + generating new table 2
Compare mulitple fields in two tables 7
Access Compare records in same access table 0
Comparing columns in two otherwise identical Tables 5
Compare table for changed data 1
?Compare data in two tables 2
Comparing two tables and updating one of them 3
Comparing data between two tables 3

Back
Top