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

Z

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,
 
S

Sam Wilson

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

Sam
 
Z

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top