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.

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.

 
 
 

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


Ron