If I remember the issue with this problem is that when exporting a memo
field that may reside other than the end of the field list, the data in the
memo field gets truncated. I vaguely remember reading that placing the memo
field at the end generally will work. However, I also vaguely remembering
that you may have to write code to export the data in the memo field in 100K
increments and append each 'chunk' to each other. See 'Append Chunk' or
exporting BLOB data in Access help.

Additional Info about this problem. Make this site your friend. Be sure to
bookmark it for future information.
http://support.microsoft.com/default.aspx?scid=kb;en-us;281153&Product=acc2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;259893&Product=acc2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;208801&Product=acc2000

All fields exported to Excel 97 and lower will be
truncated to 255 characters. Therefore, when exporting to
Excel make sure you reference the Excel version higher
than 97, by putting an 8 in the commandline for
transferring the database to Excel as follows:

DoCmd.TransferSpreadsheet acExport, 8, strQry, strAll,
True, ""

whereby the 8 stand for the Excel version (5 means 97 or
lower), strQry stands for the name of the query creating
the dataset you want to export, and strAll stands for the
name of the Excel file you want to create.

Hope this helps, at least it does for me.

Bakema