exporting data to Excel

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

 

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