Export table tot Excel, memofield truncated to 255 chars

[Crookshanks]

Hello,

See the above known problem. I know why it occurs and how to prevent it manually. If you export a table from the database window and point out that the format should be "Excel 97-2002" then the whole memofield is copied to excel. No problems here.

However, I want it do programmatically with one line of code, something like this:

DoCmd.OutputTo acTable, "tbl_Projecten", "Microsoft Excel 97-2002(*.xls)", diroutput, False, ""

The system exports the table without a warning and truncated the memofields.

Q: Is it possible to export a table automatically without cutting the memofield in little pieces?

Regards,

 

[PHV]

What about the DoCmd.TransferSpreadsheet method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Crookshanks]

That works. Thanks PHV.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tbl_PROJECTEN", diroutput, True
Did the trick!