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