Truncation when exporting to excel

L

Liz Simmonds

I have a memo field which is part of a report Im exporting
to Excel and it keeps getting truncated. Is there any way
around this?

Thanks
Liz
 
K

Ken Snell

How are you exporting? Via File | Export process? That process uses "old"
EXCEL specs that will truncate long (greater than 255 characters) strings.

Use a macro and do the TransferSpreadsheet action. Select the EXCEL version
of 97 or higher version as the argument for file version.

Or use VBA code and use DoCmd.TransferSpreadsheet in similar way.
 

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
import csv truncation 1
Exporting Memo Field to Excel 1
Truncation problem 6
Export Problem 1
Memo truncates when exporting to .txt file 4
can i extend the default limit of 256 bytes on memo fields? 1
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1

Top