How to export memo field without cutting off at 255 charsacters

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?
 
J

Joe Fallon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXPORT QUery with memo field to excel, truncated data 2
export access memo fileds to excel 2
Export and Analyze With error 1
TransferSpreadsheet still truncates the memo field 1
Export to Excel Cuts Off Data 1
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
Export Access Table with Memo Field to Excel 2
Make Table Query Truncating Memo Field at 255 Characters 2

Top