VBA Routine that will compare 2 tables. (identify differences)

[kramerica]

I am looking for a VBA routine that will compare two tables or recordsets and identify the differences.

So I could pass it two table names and it could identify what is different between the 2 tables.

Does anyone have any code to share? It would be greatly appreciated!

Kramerica

 

[SgtJarrow]

check the unmatched query....from the query wizard.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com