Access Export Problem

  • Thread starter Thread starter PowerLifter1450
  • Start date Start date
P

PowerLifter1450

Hi all, I have a memo field in a query (Access 2003 / WinXP) that I am
trying to export to Excel. When I do the export manually, it exports
the column fine, with nothing being truncated. However, when I use a
macro to do the export (Output To Excel 97-2003) the memo field gets
truncated. Any ideas why this is happening, and/or what I can do to
fix this? Thanks for any information!
 
OutputTo action uses EXCEL 95 format, which does not support text strings
longer than 255 characters. Use the TransferSpreadsheet action instead, and
specify the most recent version of EXCEL in the EXCEL format argument.
 
Back
Top