I&#039m trying to copy a record from an Access table to another table (identical except for the addition of a couple of extra fields). The statements work except for the inserts into the Memo fields. It apparently chops at 253 characters and returns this error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression &#039&#039yada yada yada text in memo field (253 characters)&#039. <BR><BR>My code simply inserts a new record (via SQL statements) into table #2 with references to the data from the RecordSet. The statement has no problem with anything else and I get the same EXACT error if I change the field in Access to Text instead of Memo?<BR><BR>HELP!<BR>