solution:

write your own routine using ADO
examples on www.erlandsendata.no


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGFu?= wrote:

Hi!

I am using the TransferSpreadsheet function (in Access) to export an
Access (2003) table to an Excel spreadsheet. The problem is fields
that have more than 255 characters are being truncated to 255 in the
new Excel sheet it created. Any ideas on how to get around this
issue?


Thanks a lot for any help!

Dan