Community
Showing results for 
Search instead for 
Do you mean 
Reply

Using OLEDB connector to pull notes into excel? Crashes Excel?

New Member
Posts: 5
Country: United States

Using OLEDB connector to pull notes into excel? Crashes Excel?

I am trying to export my notes into a CSV file.

 

I found this KB article:

 

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1402...

 

I follow the instructions exactly and everything is good right until the last step where i am to actually pull the data into the worksheet. This crashes excel and it asks to send an error report to Microsoft. Is this because the notes field is too big for Excel to handle?

 

I am running ACT! by Sage Premium 2008 (10.0) (ST Edition) Version 10.0.3.182, Hotfix 1

 

The ultimate goal is to not spend any money buying the 3rd party applications out there like IT Export or Exporter for ACT!. 

 

Any help would be greatly appreciated! Thank you.

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Using OLEDB connector to pull notes into excel? Crashes Excel?

Yes, you're right. Excel has a max size of data for the field and won't usually be able to cope with Notes type data