Exporting Memo Field to Excel

  • Thread starter Thread starter Chris H
  • Start date Start date
C

Chris H

In Office 97 when I export a memo field to Excel, the
field truncates at about 250 charecters in the Excel cell.
Is there any way of exporting an entire memo field to
Excel without this truncation?
 
The truncation is at 255 characters.....

Are you using the manual export process (File | Export )?

If yes, try using a macro or VBA code to run the TransferSpreadsheet action.
This often works for memo fields being exported. If that also fails, then
your only other recourse is to use VBA code to run Automation and write
directly into the EXCEL file.
 
Back
Top