truncated text when exporting to excel?????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to export data from Access to Excel and the memo fields are being
truncated? Do you have any idea of why this happens and how to prevent it?

Thanks
Rob
 
If you're using the File | Export method, then what you're seeing is normal
behavior -- that method (as does the OutputTo method) uses an older version
of EXCEL for the export; that version doesn't support more than
approximately 16,384 records or more than 255 characters in a string.

Instead, use a macro to run the TransferSpreadsheet action. Or use VBA code
to run the DoCmd.TransferSpreadsheet method.

See Help for info on either of these suggestions.
 
Back
Top