Maximum size of memo field

[Guest]

I'm trying to append a single field query into a table with a single memo
field and I get the message "record too large".
Its size is 22,000 bytes.
However, I can copy & paste it in.
Any suggestions or advice please?

 

[Douglas J. Steele]

What does your code look like?

 

[Guest]

I'm not sure if this is what you want, but this is the SQL of the append query

INSERT INTO FileExchangeExportTo ( Description )
SELECT [FE-Ex-Add-ATMultis].Descr
FROM [FE-Ex-Add-ATMultis];