Michel,
I had the same problem (the truncation, but from an input file not Excel),
but found a solution...
The problem appears to be with the way the import routine works... instead
of looking at the table and seeing that the field is a MEMO field, it must
interrogate the first few lines in the input file, and "guess" at the field
type. I found someone's suggestion in another newsgroup to modify the input
file to have the record with the long entry appear first in the file, tried
it and magic, it now works!!
Admitedly, I'm importing from a text file... you don't specify whether you
are importing directly from Excel or via a text file. If direct from Excel,
try moving one of the rows that has a cell with > 255 characters to the top
of the sheet, and see if that helps.
Cheers,
wibbler.
