In addition to Bob and Eric's suggestions you can use INSERT and UPDATE commands with SQLExec()
>HI,
>
>I recently installed SQL-Server 7.0. I'm able to create tables in SQL server. I can also view the tables with connections and remote views.
>But what do I have to do to change or append records.
>Can Someone help me?
>
>Tnx
>
>Werner_vaneylen@iname.com
>Belgium