Finding duplicated records from 2 files

[Rangoon]

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

[BobWeaver]

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.