How to save Excel 2010 with Memo fields 1

[markros]

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

 

[brigmar]

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.

 

[foxmuldr2]

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

 

[TamarGranor]

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