memo field truncated in excel

memo field truncated in excel

Post by TENvbG » Thu, 21 Feb 2008 08:47:01

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?

memo field truncated in excel

Post by Allen Brow » Thu, 21 Feb 2008 10:38:25

There are some known problems with exporting to Excel.


Or, it could be some of the more general issues as to why the memo is being

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
Reply to group, rather than allenbrowne at mvps dot org.


memo field truncated in excel

Post by Ron200 » Fri, 22 Feb 2008 01:37:40

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