How to detect duplicate records while importing

[SKV]

I am importing data every week, which has records from previous download also but certain fields for that record are updated.

To keep the database up todate I have to compare each new record to the existing record to check for an update. This take a lot of time and I want to update this process such that while importing access should tell me which fields in a record have changed and of the which records I want to import.
It should display the old record and new record with changed fields highlighted in red

 

[alansidman]

Have you considered using the Unmatched Query Wizard available to you. Open the Query Object and click on new. Then click on Unmatched Query. Follow the wizard.

Alan