Eric,
here are my notes on data truncated when exported to excel
There are some restrictions on exporting memo fields with contents
longer than 255 characters to Excel without truncating them. As far as I
can make out they are:
-You need to be using Office 97 or later.
-You must export a table or query, not a report.
-You must export to Excel 97 or later format.
-You must export using File|Export (without checking "Save Formatted")
or DoCmd.TransferSpreadsheet. Don't use "Analyze it with Excel" or
DoCmd.OutputTo.
-The memo fields must not be formatted (e.g. using the Format property
of the field to convert it to upper case). This causes them to be
treated Text fields on export and truncated at 255 characters.
-They can't be calculated fields (e.g. several shorter fields
concatenated together) or a field generated by some other expression.
These too are treated as Text fields when exported. To get round this,
you have to append the records to an Access table and then export that.
http://support.microsoft.com/default.aspx?scid=kb;en-us;207668
When you export a query that contains an expression that results in more
than 255 characters, the expression is truncated in the exported file.
Microsoft Access evaluates the expression as a Text field, and Text
fields have a maximum length of 255 characters. When you export the
query, Microsoft Access truncates anything after the 255th character.
Jeanette Cunningham
