03-11-2009 08:10 AM
Using ACT! Premium ST Edition V 10.0.3.182
I saved my Excel spreadsheet (MS Office 2003 Pro edition) as a CSV and tried numerous times to import the data and nothing is imported into ACT!
The spreadhseet is one column, 850 lines, of email addresses. I mapped it but nothing seems to work. I then tried to add a second column entitled SOURCE ID. Saved it as a CSV and again, nothing was imported.
When I save the Excel file as a CSV I get the following message:
"The file contains features that are not compatible with CSV. Do you want to keep the workbook in this format?"
Any ideas of what I am doing wrong?
03-11-2009 08:44 AM
03-11-2009 10:00 AM
03-14-2009 03:43 PM
I don't know why you would, but if you just want to bring in the email address into new otherwise blank records, you'd need to turn off duplicate checking - Tools | Preferences | Duplicate Checking
Otherwise, it will see each record as a match and either skip or overwrite (depending on merge settings) the first record