Memo fields not exporting to Excel correctly - missing data

G

Guest

Running a maco that transfers spreadsheet to Excel Template and some of the
data in the memo fields is not exporting.
 
G

Guest

All the spreadsheet functions truncate the memo field (it's a Microsoft
feature). Create a temp table with the query and export the table.

(Do a search within this newsgroup for more detailed explanations and links.)
 

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

Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
EXPORT QUery with memo field to excel, truncated data 2
Losing data from memo field when exporting to Excel 6
Export and Analyze With error 1
export to excel - automatic wrap text 3
Exporting Memo Field to Excel 1
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
exporting data to Excel 1

Top