I have two files [CONTACTS] and [NEW DATA]. Both files contain the same fields.

What I want to do is import the information from the [NEW DATA] file into the [CONTACTS]file and delete any duplications by phone number.

How is the best way to do this and also retain data integrity.

Thank you, your help will be most appreciated.

Harry

Once you import the records, execute a script similar to the example given on page 10-13 of the manual "Finding duplicate records."

This script will mark the duplicates. Then you can add a couple of steps to the script to find the marked records and then delete the found set.