ADO help : 255 Character limit on memo field....!??!?!?

[zqureshi120]

Hi,

can somebody help with this?

I have an Access database, that has a table with a memo field in it.
This table contains
records longer than 255 characters.

I am using ADO to get this info out of the database into a recordset,
and then loop through the
recordset to populate a spreadsheet.

However, I only get the first 255 characters for the data that comes
from the memo field.

How do I get the entire value stored in the database?

Somebody mentioned using "adLongVarWChar". But how do I do this?

Please help,

Thanks,

 

[Stefan Hoffmann]

hi,

However, I only get the first 255 characters for the data that comes
from the memo field.

Are you grouping by this field? Jet truncates the memo content for these
operation.

mfG
--> stefan <--

 

[zqureshi120]

hi,



Are you grouping by this field? Jet truncates the memo content for these
operation.

mfG
--> stefan <--

Hi,
No I am not grouping by this field.
When I retrieve the values from the memo field into a recordset. The
truncation to 255 happens. But how do I get the entire string out from
the database using ADO and then into my spreadsheet?

 

[Stefan Hoffmann]

hi,

No I am not grouping by this field.
When I retrieve the values from the memo field into a recordset. The
truncation to 255 happens. But how do I get the entire string out from
the database using ADO and then into my spreadsheet?

Can you post the piece of code?



mfG
--> stefan <--

 

[Stefan Hoffmann]

btw, take a look at

http://allenbrowne.com/ser-63.html


mfG
--> stefan <--