>I am retreiving data from a remote data source using sql pass through. I can send updates ok but how do I append a new record?

Look up the Transact-SQL command "Insert" in the SQL Server Help. You can use Insert with SQL passthru to add records.

Bill