I have a recordset open accessing an Access database and I want to update the results to an SQL Anywhere database. Is there anyway that I can use the SQL insert command so that it recognizes the source as the Access database, or is the only way to update the SQL Anywhere table is through stepping through the recordset and using the Addnew Array thanks in advance.