memo field truncated in excel

[LCole]

From a select query results, use copy command, pasted in excel - memo fields
do not contain all the text that database has. (database had 409 characters).
Also tried Tools - Office Link from menu to create an Excel file; same
results. Any suggestions?

 

[Allen Browne]

There are some known problems with exporting to Excel.

See:
http://support.microsoft.com/kb/208801
http://accessblog.net/2006/07/export-to-excel-range.html

Or, it could be some of the more general issues as to why the memo is being
truncated:
http://allenbrowne.com/ser-63.html

 

[Ron2006]

to remedy the 256 byte truncation when exporting into excel

===============================

If you use the menu File, Export, you should be able to
select Excel 97-2000 as the file format. I would make
sure you have a complete install of MS Office.

If you are using VBA and the TransferSpreadsheet Method,
The spreadsheettypes is 8.
8 acSpreadsheetTypeExcel8


Ron