>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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.