Memo Field Limited to 256 When Export to Excel

[AGGGG]

Hi,

I have created a macro that exports a query to excel, but it appears to be limitting to the first 256 characters of a memo field, hence I lose any data > 256 characters, when I open in excel.

Any pointers ?

Cheers,
Andy

 

[Remou]

Have you applied service pack 3?

http://support.microsoft.com/kb/326605/en-us

Have you formatted the memo field?

 

[AGGGG]

I am using SP3,

Hope this isn't a silly question, in design view of the table, when I select the memo field, there is an empty list box when I select it.

 

[Remou]

I think you have lost me. Perhaps you could explain a little more?

Here is some more information on truncation and memo fields:

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

 

[AGGGG]

Hi Allen,

thanks for the link, looks like the answer is in:

http://support.microsoft.com/kb/208801/EN-US/

Cheers,
Andy