exporting data to Excel

P

PJ

I have a field name that has a data type of Memo. When I export to excel
this only part of the data from this field exports to excel. Do I need to do
something to get all the data to export to excel with the data type is memo?

Thanks in advance.
 
K

Ken Snell \(MVP\)

Use TransferSpreadsheet action in a macro or VBA code. If you use File |
Export method or the OutputTo macro action, that will cause truncation of
Memo fields because this method uses EXCEL 95 specifications, which do not
allow strings longer than 255 characters.
 

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

Top