[AccessD] Exporting Memo Field

Hello to the Group,
I need to manipulate some text which in memo fields.
When I try to parse it in VBA, I seem only to be able to access the first
255 chars.

I thought that I had solved the problem by copying the whole table to Word.
I know this sounds funny, but it worked. It pasted into Word in the form of
a Word table. 

I thought that then it should easy to copy back into Access, or into Excel
and then into Access. The latter seemed to work. But when I started to
process the newly created table that I pasted into from Excel, I discovered
that again I only had the first 255 chars.

How can I "access" this data?

TIA,

Bob Heygood