Comparing Fields in Two Tables and Showing Differences (SQL Except)

[afinch300]

Hi,



Wonder if anyone can help, really stuck on this one and can't seem to work my way out of it even with reading many threads online,

I want to be able to take a table which is populated with imported data and compare it to the table of data that already exists within the database.

I want to be able to highlight with a query which records are different in the uploaded data to that of the existing data, I managed to get this to work in SQL using the except function however I am not able to use a web app for this project and have to use MS Access (not a problem, just can't seem to get the except functionality to work in Access).

Any ideas??

[CJ_London]

I presume both tables share the same PK so you can link on them. In which case your query would be something like

SELECT * FROM
TableA INNER JOIN TableB on TableA.PK=TableB.PK
WHERE TableA.fld1<>TableB.fld1 OR TableA.fld2<>TableB.fld2 OR TableA.fld3<>TableB.fld3 OR....etc

If you have more than 9 fields (PK excepted, no point in comparing that), you will need to build in the sql window as the query grid only has space for 9 criteria rows