>>
>>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.
--sb--