MsAccess table comparisons
Posted on 2011-03-24
Hi All -
I have two huge tables (900,000+) that have the exact same structures. I would like to compare every field (93) in each table to determine where the differences are. A field in Table A could have a Null and the same-name fields in Table B could be a zero. Also, corresponding fields in each table could both be Null.
I tried a join (just to produce exact records in each table) but that did not seem to be working as I wanted.