Developer Forum

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?

There are some known problems with exporting to Excel.

See:
http://www.yqcomputer.com/
http://www.yqcomputer.com/

Or, it could be some of the more general issues as to why the memo is being
truncated:
http://www.yqcomputer.com/

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

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