EXPORT QUery with memo field to excel, truncated data

  • Thread starter Thread starter BlueWolverine
  • Start date Start date
B

BlueWolverine

Hello,
MS OFFICE (ACCESS/EXCEL) 2003 on XP PRO.

I have a query with several fields, one being a memo. I want to export the
query to an excel file. When I do this, the data in the memo field truncates
to 255 characters. This is a problem for me.

Is there any way around this problem?

Thanks,.
 
If you export to XML instead of Excel you can work around this problem. You
have to open the output in excel, convert to range and format the affected
cells as GENERAL. :)
 
Export to EXCEL using TransferSpreadsheet (via a macro or VBA code). It
handles memo fields without truncating the data string.

Using File | Export or using OutputTo (via a macro or VBA code)
will truncate memo fields.
 
Back
Top