Exporting Reports to Excel (1 Viewer)

[RJ]

Morning all
I have a report that I want to analyze in excel. I exported it using office links, nearly all is ok except two fields, both of which are free text with a data type "memo" as the length is longer than 255. My problem is that access only exports the first 255 characters, is there a way to get my entire field into excel?
Any thoughts appreciated.
Thanks
Richard

 

[Fornatian]

The maximum length of a cells contents in excel is 255 characters.

The only way I can think is to split the contents of the memo box in 255 character chunks using query column expressions.

There may be an easier work around, but I'm sure you can't extend the excels character limit.

Ian