Truncated when exported to excel

[memaxt]

Hi all,

I'm trying to export my table using the following code:



DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "incidents", "c:\Incidents.xls", True

But unfortunatly I get truncated errors upon export via the vba above. is it not possible to export memo fields to excel via vba?

any ideas?

[June7]

Bing: access export excel memo field truncate

Maybe this still applies: http://support.microsoft.com/kb/294286

and http://allenbrowne.com/ser-63.html

and http://answers.microsoft.com/en-us/o...7-5462fee72a50