Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing data from excel where duplicates will appear

New Member
Posts: 2
Country: United Kingdom

Importing data from excel where duplicates will appear

Hi, I am new to the forum.  Have been using ACT for a while now and have an established database.  I would like to import a new file to the database, however I know that there will be tons of records in the new data, that are already in ACT.  Is there a simple way to import the file and ask it to ignore any that already exist as contacts?  I haven't done any importing as yet, as I took over the database as it was.  Any help anyone can offer would be appreciated.  Thanks
Copper Contributor
Posts: 27
Country: United States

Re: Importing data from excel where duplicates will appear

Enable the duplicate checking under tools, preferences, duplicate checking.  When importing the excel database save it to a CSV file and make sure your fields match your ACT fileds.  When doing the map make sure you that you do not have it add the duplicates.  I learned the hardway.
New Member
Posts: 2
Country: United Kingdom

Re: Importing data from excel where duplicates will appear

Thanks so much for the reply.  We will give this a go!