02-15-2012 08:18 AM
I imported a larger excel file of around 28,000 contacts into ACT! around a month ago. However, I realized that I did not import a column that I would like to be in the "Last Results" field in ACT. This column affects only around 4,000 of the 28,000 contacts.
I seperated the 4,000 from the original spread sheet and renamed all the columns to match the corresponding ACT! fields. I planned to just import and replace all of the Contact data in ACT! with the excel contact data for these people. However, when I try to import these people (4,000 from the original 28,000 already in ACT!) it tells me that only 3 records are "merged" and adds duplicates of the remaining 3,997. How is this possible? I realize that you can edit the duplicate checking criteria but all of the information is exactly the same, so there should be 4,000 perfect matches. So, I then attempted to do it with the "merge" option rather than the "replace" option but the results were the same. Luckily, I backed up before trying so I just restored and am able to prevent the duplicates by selecting the Do not add option but I still can't get the records to update.
I would appreciate any insight into how to fix this because I really do not want to update 4,000 records manually.
10-16-2012 07:05 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.