Put your text file into a variable.

lcMemo = your text file.

Then

SQLEXEC(ch,"INSERT INTO mytable (field1,field2,mmemofld) VALUES (?cValue1,?cvalue2,?lcMemo)")

Or if doing an update

SQLEXEC(ch,"UPDATE mytable SET mmemofld = ?lcMemo WHERE pk = ?yourpk")

>Hi all
>
>I need to seek your advice on how to convert the following to use SQL PT to insert /update varchar fields in MSSQL from a text file :
>
>INSERT INTO mytable (field1,field2,mmemofld) VALUES
> (cvalue1,cvalue2,"") APPEND MEMO mmemofld FROM (".\mytext.txt")
> OVERWRITE
>
>
>Thanks & Best Regards