ADO help: Only get first 255 characters of field...
 

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,

ADO help: Only get first 255 characters of field...
 

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

Sam

" wrote:

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,

ADO help: Only get first 255 characters of field...
 

On 8 May, 14:44, Sam Wilson
wrote:
Make sure that the memo field is the last field selected in your SQL
statement/the last field in the table.

Sam



" wrote:
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,- Hide quoted text -

- Show quoted text -

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