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