exporting data to Excel

  • Thread starter Thread starter PJ
  • Start date Start date
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.
 
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.
 
Back
Top