CopyFromRecordset only pastes 1823 characters in a cell!?
 

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

CopyFromRecordset only pastes 1823 characters in a cell!?
 

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

CopyFromRecordset only pastes 1823 characters in a cell!?
 

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

"John Green" wrote in message
...
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

CopyFromRecordset only pastes 1823 characters in a cell!?
 

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

"John Green" wrote in message
...
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

CopyFromRecordset only pastes 1823 characters in a cell!?
 

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

"John Green" wrote in message
...
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

CopyFromRecordset only pastes 1823 characters in a cell!?
 

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

--


Julian Milano

"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