Memo field to Excel

[Pekka]

Hi;
I'm trying to output my query to excel. Excel is cutting memo field to 255 characters. Is there any way to override that limit other than splitting the memo to pieces?

Pekka

"every dog will have his day

 

[M8KWR]

how are you exactly outputting it to excel:-

are you right clickiing on the query and saying save as.
copying a pasting the info into excel.
clicking on the "Analyze It with MS Excel"

If could be the way you are outputting it, because i had to same issue some years ago now.

 

[Pekka]

I used "Analyze it with..." I noticed that in Excel 2002 you can open mdb from excel and with that memo fields returns as expected.

Pekka

"every dog will have his day