CopyFromRecordset only pastes 1823 characters in a cell!?

[Julian Milano]

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

 

[John Green]

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.

 

[Julian Milano]

Thank you John for your time.

I will replace all CopyFromRecordset statements with
"CustomCopyFromRecordset" whereby I will write a function to loop thru the
fields.

Thanks so much.

--


Julian Milano

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

 

[Julian Milano]

Thank you John for your time.

I will replace all CopyFromRecordset statements with
"CustomCopyFromRecordset" whereby I will write a function to loop thru the
fields.

Thanks so much.

--


Julian Milano

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

 

[Julian Milano]

Thank you John for your time.

I will replace all CopyFromRecordset statements with
"CustomCopyFromRecordset" whereby I will write a function to loop thru the
fields.

Thanks so much.

--


Julian Milano

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

 

[Julian Milano]

Sorry for the multiple posts- my OE went sick over the w/end.