How to export memo field without cutting off at 255 charsacters

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

Guest

When I use the export function or click the prebuilt button &analyze it with
Microsoft Excel button it cuts my memo fields off at 255 characters. How do I
export data on a form without it cutting off the memo fields?
 
The button uses OutPutTo which caueses the behavior you are seeing.
Use TransferSpreadsheet in VBA code instead.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, strTableName,
strLocalDir & strLocalFileName, True

Works great for A2000 and later.
A97 and earlier may have issues.
 
Back
Top