How can import data from Excel?

[martamo]

I have an Excel spreadsheet that I would like to transfer to ACT!9.0. I have created a custom map for the different fields and I have tried to import the records using the import wizard. I have tried converting the data into CSV and also to separating the information by tab.but nothing seems to work. Although ACT! doesn't give me any error message and apparently the information has been imported I noticed that almost all the records are missing in ACT!.

I am new using ACT! so I am a bit confused!

Thanks in advance

 

[GLComputing]

I've seen this if you've tried importing to the secondary fields or if you have the duplicate checking turned on to fields that are not always filled.

Personally, I always perfer to use itImport to bring data into ACT!... very powerful and much more flexible -

http://www.glcomputing.com.au/main.php?prodid=57&s=1

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

For ACT! by Sage and ACT! for Lotus Notes

 

[martamo]

Thank you!I will try that!

 

[Djon43]

Excel > ListGrabber > Act! (for sure)


Excel > AddressGrabber>Act! (maybe..have not tried)

http://www.egrabber.com/

 

[TrainingCnsrtm]

Check out my FAQ for importing.

http://www.tek-tips.com/faqs.cfm?fid=6642

I don't know if this will work as a link but I will try it.
<a href="

http://www.tek-tips.com/faqs.cfm?fid=6642"

target="_blank">Importing From Excel FAQ</a>