Hi Lazzaroni,

The article does not provide a workaround, but there must be one
since using Tools Import External Data or Microsoft Query in Excel

then you have to use the import function or ms-query. I think, There's
no way to do this with copyfromrecordset. I have the same problem with
memofields from foxpro databases, however, I simply cut only a hundred
characters as I do not need to know the content of these fields and
this avoids the error.

arno