Finding the difference between two tables

[bengalliboy]

Hi Gurus!
What is the best way to comapre two tables (All the fields ) and determine the changes? Note I have got both table same structure, only difference in Data.


TIA

 

[rac2]

The best way I suppose would be to avoid the situation that produced this problem. But usually management wades into the river before they ask us if it is home to crocodiles.

So you might get some ideas about how to proceed from my recent post to a similar question, thread701-909427 in the Microsoft Access and Jet SQL Forum.

 

[ingresman]

Or if this is a one off, extract the two tables into flat files and diff them (on Unix) or find a windiff on windows.