Background of what I am doing: I am linking the tables from SQLServer 6.5
into Access through ODBC using translator code page 1252 selected in the
configuration of my datasource. The tables that I need to update is simple:
delete the old data and insert or append with the new data.

My ODBC connection is failing when I try to insert a string (datatype
memo) from Access into SQLServer. I determined the length of one string to
be 1829 characters long & the other to be 2044 as a sample. The table has 3
fields, Id & type which should not be giving me any greef but the last
field (memo datatype) is giving me problems and causing the ODBC failure. Also, please note that in SQLServer the last field is Text(16).

I'm new to this field so whoever responds to this message, please keep your answer as simple but detailed as possible. Thanks in advance!!!