Compare two tables

[kirkm]

Is there an built in way to do this ?

I don't need to know what any differences are, just if the 2 tables are identical or not.

Thanks

 

[jdraw]

Different in structure, or different values?
Can you give a few details?

 

[kirkm]

Either really. The structure would (should) always be the same but if it isn't it would mean they're different. As should any data differences.
Is that enough ? I'm not sure what answer you want.

 

[jdraw]

Can you use an unmatched query with the 2 tables involved?

 

[kirkm]

Possibly, I read something about that via Google. But it seemed a bit complicated.

 

[jdraw]

How big are the tables(number of records) and how many fields?

Consider tblA and tblB.
Do an unmatched query using the wizard on tblA and tblB(tblA not in tblB)
something like this where Address is one or more important fields(keys) in each table.

SELECT *
FROM tblA LEFT JOIN tblB ON
 tblA.[Address] = tblB.[Address]
WHERE (((tblB.Address) Is Null));[code]

If you get any results, you'll know something is different. You can look at the results and select a field or 2 to investigate the record(s) further.

You can also try the unmatched query and reverse the tblA, tblB to check tblB not in tblA.

Good luck.

 

[kirkm]

Thanks... I tried it but it told me 'Too many fields defined'
Which probably was why you asked how many records & fields.
There's 239 fields and 39257 records.