ADO help: Only get first 255 characters of 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,

 

[Sam Wilson]

Make sure that the memo field is the last field selected in your SQL
statement/the last field in the table.

Sam

 

[zqureshi120]

Make sure that the memo field is the last field selected in your SQL
statement/the last field in the table.

Sam













- Show quoted text -

I have tried this, but it still truncates the field.