>>
>>Use SPT parameters to pass memo fields into SQLEXEC().

lcSql = "INSERT INTO myTable (TextColumn) VALUES (?MemoField)"

>
>This works, I get no error messages. Thank you very much. I guess I will have to read some SQL Server documentation to understand what is the difference between (?MemoField) and what I used before, "'" + MemoField + "'".

You can use SQL Server Profiler to see how they are passed.