Truncating a CLOB field to 255 Chars

Hi

I'm trying to im****t a DB2 Table into access for user interogation.

I've tried Im****ting the Data via ODBC, Attaching a linked table (again
ODBC).
in both occassion the CLOB field comes across as a TEXT field and thus 
trucates the field to 255 chars.

I've tried creating the table with a MEMO field and then running a query 
from the attached table to the insert into the MEMO field, again to no
avail.

Anyone suggest anything else?

This is really causing me issues at the moment.