Maximum size of memo field

N

Nags

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?
 
N

Nags

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];
 
Top