Importing data without duplicating records
I'm trying to inport some data from excel. some records already excist and some don't. I want to create new records for those that don't excist and append the ones that do.
1)gone to import records>files and selcted the excel spread sheet
2)matched the fields up that are to be added/appended
3)under import action i selected "update matching records in a found set
4)on field mapping i have matched records based on email address
6)preformed auto enter was ticked
It then created all of the entries as new records. I know for a fact that quite a number of them are duplicates with the same email.
What am i doing wrong???