Data lost during export to Excel

[TAB]

Help!

I am trying to export a form to excel (which then runs
macros to jazz it up etc) but one field loses data. The
field is set up as a memo field and can contain quite a
few characters.

Is there anything I can do to solve this.

Cheers
TAB

 

[Ken Snell]

If you're using the File | Export option from the menu bar, then this
truncation will happen because that method uses the old EXCEL file format
(95, I believe), which doesn't support the long text strings.

Instead, use a macro or VBA code to use TransferSpreadsheet to export the
table or query to EXCEL.

By the way, I assume you're not trying to export the form....just the data.