memo field truncated in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LCole - 19 Feb 2008 23:47 GMT

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?

Reply to this Message

Allen Browne - 20 Feb 2008 01:38 GMT

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

Signature

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

> 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?

Reply to this Message

Ron2006 - 20 Feb 2008 16:37 GMT

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

Reply to this Message