MS Access 2003: Remove duplicates?

I have a contact manager DB in Access 2003. I receive new contact data daily from my dispatcher which I then import into Access as a text file.

It is possible that data can contains records that I have previously included on earlier imports. This causes duplicate contacts to appear in my DB.

Example: I have two imports. Mary Smith at 120 Main street is included in both imports.

A simple find duplicate query has no problem finding the duplicate records.

However, in some cases I have already changed the data that came in the first import.

Example: After importing the first batch of data I have scheduled an applointment with Mary and recorded the date and time in her original record.

All records are given a unique ID #

I need to create a Find and Remove Duplicate query that will find my duplicate contacts (i.e., all records for Mary Smith at 120 Main Street) ,,, then Identify and delete any duplicate contact record from second import.(i.e., those records containing the higher contact ID# that DO NOT contain the appointment Date and Time information.)

The resulting table should contain only unique records (if duplicates were found the records containing the higher contact ID would be deleted.

Example: only one record for Mary Smith that also contains the appointment date and time info.

I hope that makes sense. It sounds simple to me but it is a couple steps beyond the basic find duplicate query and beyond my puny brain capacity to figure out and design.

Any help will be much appreciated.

thx

Jerry