Julian,

I have confirmed your findings using both ADO and DAO. I donn't find it very surprising that such limitations exist. Excel and VBA
have always had many limitations in transferring data, many of which have been ameliorated in new versions. You will need to access
the field separately, as you have found.

--

John Green - Excel MVP
Sydney
Australia


"Julian Milano" wrote in message ...
Range(FirstDataRange & "3").CopyFromRecordset rstData

That's it. This is my problem line. The last field in the recordset is a
MEMO field stored in an Access db. The field contains about 50-odd thousand
characters. Whent the above line executes, the cell containing the last
field of the recordset only contains 1823 of the last field's value.

range("fc10")=rstdata.Fields(158).Value

This line actually works differently. It copies 32,767 (the cell's
limitation) of the last field's value, which is what I was expecting from
the CopyFromRecordset function.

Why does the CopyFromRecordset function not paste more characters?

XL2002, Access2000 db, WinXP

--


Julian Milano