Memo Field Truncating

[Nancy]

I have a field in a table defined as Memo. I'm trying to import fixed length
data of 5000 characters. It truncates after about 500 or so characters.
This is Access 2002. What should I do so that the data is imported?

Thanks for your help.

 

[John Nurick]

Hi Nancy,

If you're getting any error messages when you try the import, please
post the details here. Otherwise,

-The first thing I'd suspect is the import specification. Have you set
the starting points and lengths correctly?

-Then I'd scrutinise the text file. Are there any line breaks in the
data? or null bytes? or binary data? All these can screw things up
nicely. Is it a true fixed-length file, or do the records consist of a
bunch of fixed-length fields followed by a variable-length memo field?
If the latter, pad the records to a constant length.

You don't mention how you're importing the data. Are you using an append
query that uses a calculated field to modify the memo text in any way?