I am trying to import a spreadsheet into Act 2005. I have converted the excel sheet into a tab delimited file and follow all of the prompts. However, after the last prompt says that the file was imported, when I look in Act, there is nothing. What am I doing wrong. Thanks in advance for the help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import Question
- Thread starter dyow
- Start date
Storyteller
Instructor
Hello dyow.
During the import process did you map the fields? In other words did you make sure the data from the excel spreadsheet was going into the proper ACT! fields?
Only if the column headers from the excel data exactly match the field names in ACT! will the fields be mapped automatically. Otherwise, it has to be done manually.
Regards,
Michael
During the import process did you map the fields? In other words did you make sure the data from the excel spreadsheet was going into the proper ACT! fields?
Only if the column headers from the excel data exactly match the field names in ACT! will the fields be mapped automatically. Otherwise, it has to be done manually.
Regards,
Michael
Frustrated123
Technical User
dyow,
I can see 2 possible reasons for your problem;
1 - 1st row should be field names (export a record and use the field names from that.
2 - Save the data as a CSV (comma Seperated variable).
Paul.
I can see 2 possible reasons for your problem;
1 - 1st row should be field names (export a record and use the field names from that.
2 - Save the data as a CSV (comma Seperated variable).
Paul.
- Status
Similar threads
- Locked
- Question
- Locked
- Question