Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act 2013 - how do you import an excel cell contents to History

New Member
Posts: 7
Country: Australia

Act 2013 - how do you import an excel cell contents to History

Understand how to import and match excel cells to ACT fields but cant see how to import contents of an excel cell called "Comments" to History Any ideas please?
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Act 2013 - how do you import an excel cell contents to History

[ Edited ]

Hello Wayne,
Unfortunately, you cannot import Excel data directly into History. You can import to Notes though by choosing "Add to ACT! Note" in the field mapping.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 2013 - how do you import an excel cell contents to History

New Member
Posts: 7
Country: Australia

Re: Act 2013 - how do you import an excel cell contents to History

Thank you Greg - a great help and quick!!

Any thoughts on why I am having trouble importing numbers greater than 1,000 but no problems with a small number. The ACT field just imports 0 even though the excel cell is over 1,000. Both fields are "numbers" 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Act 2013 - how do you import an excel cell contents to History

I'd check the formatting of the numbers ... tell Excel to remove the , for exampe
New Member
Posts: 7
Country: Australia

Re: Act 2013 - how do you import an excel cell contents to History

Thanks Mike - I have been playing with the formatting of both Act and Excel and no luck so far but your comment has convinced me it is the way to go - will play around with it tonight. 

thanks again