export to excel memo filed

[24sharon]

in the excel there is just 255 length how and where I can fix it?

 

[Pauldohert]

If you are using DoCmd.ouputto try using DoCmd.TransferSpreadsheet instead.

This seems to solve the truncating of memo field when exported to excel.


I don't know if there will be problems caused with the not specifying which version of excel. I haven't checked this!

Paul