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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to save Excel 2010 with Memo fields 1

Status
Not open for further replies.

markros

Programmer
May 21, 2007
3,150
US
In the thread184-1633357 I read about solutions but they don't seem to work for Excel 2010. The memo field is getting truncated. Do you know of any way to get Excel fully output the Memo field for Excel 2010?

Thanks.

PluralSight Learning Library
 
Yes you can use Excel automation, but the speed of running that code is prohibitive when compared to OLEDB/XML

Try running that on a sheet with 50 columns and 150,000 rows.
 
brigmar,

Definitely not an idea for large data sets. But if it's a user input (which I kind of assumed it was probably because we had some inputs given us by users for that purpose), it was fine.

IIRC, we experimented with using the range("A1..Z1800") and copying into an array using an @laName reference, and that seemed to work. Can't recall now for sure. It might've only been in going from VFP to Excel, and not the other way around. Can't remember.

In my experience, anything up to about 50 columns, 50 rows is acceptable this way. Also, if you hide the excel.application instance so it's not visible, it goes much faster. However, in my experience, users like to see it processing to get that "feedback" feeling.

Best regards,
Rick C. Hodgin
 
One other point. The target machine has to have Excel installed to use Automation. The OLE DB solution requires only the Excel driver, which I believe is free.

Tamar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top