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.
 
Top