Find Duplicate/Unmatched

[Guest]

Using 2 existing Excel files, how do I compare these, using Access, for duplicate and unmatched data?

 

[Michel Walsh]

Hi,


Import them into two tables, t1 and t2.
For those appearing in both tables,


SELECT fieldToCheck
FROM ( SELECT DISTINCT fieldToCheck FROM t1
UNION ALL
SELECT DISTINCT fieldToCheck FROM t2) As a
GROUP BY fieldToCheck
HAVING COUNT(*) <> 1


For those in one table but missing in the other:

SELECT fieldToCheck
FROM ( SELECT DISTINCT fieldToCheck FROM t1
UNION ALL
SELECT DISTINCT fieldToChekc FROM t2) As a
GROUP BY fieldToChekc
HAVING COUNT(*) = 1




Hoping it may help,
Vanderghast, Access MVP

Using 2 existing Excel files, how do I compare these, using Access, for

duplicate and unmatched data?