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,

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

Sam

"(E-Mail Removed)" 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,
>
>
>

On 8 May, 14:44, Sam Wilson <SamWil...@discussions.microsoft.com>
wrote:
> Make sure that the memo field is the last field selected in your SQL
> statement/the last field in the table.
>
> Sam
>
>
>
> "zqureshi...@googlemail.com" 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.