The error message is as follows:
[ODBC SQLDriver] Implicit conversion from datatype 'text' to 'varchar' is not
allowed.

The datatype of the memo field in the SQL server is TEXT and datatype used in the FoxPro is memo. As SQL server has only Text field but not memo field and
FoxPro has only memo field but not text field.
\alvin

>>When the memo field has more than 3 lines, upon updating into SQL
>>Server, it prompted error message related to ODBC problem. But if it
>>is restricted to not more than 3 lines, it is OK.
>
>What is the error message that is returned?
>
>-Mike