C#

public void MergeTables(string connS1, string connS2)<br />
        {<br />
            string connString1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + connS1;<br />
            string connString2 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + connS2;<br />
            OleDbConnection oleConn1 = new OleDbConnection(connString1);<br />
            OleDbConnection oleConn2 = new OleDbConnection(connString2);<br />
            string cmd1 = "SELECT *FROM db1_table1";<br />
            string cmd2 = "SELECT *FROM db2_table1";<br />
            OleDbDataAdapter da1 = new OleDbDataAdapter(cmd1, oleConn1);<br />
            OleDbDataAdapter da2 = new OleDbDataAdapter(cmd2, oleConn2);<br />
            DataSet ds1 = new DataSet();<br />
            da1.Fill(ds1, "db1_table1");<br />
            da2.Fill(ds1, "db2_table1");<br />
<br />
            ds1.Tables["db1_table1"].Merge(ds1.Tables["db2_table1"]);<br />
<br />
            foreach (DataRow row in ds1.Tables["db1_table1"].Rows)<br />
                row.SetAdded();<br />
<br />
            OleDbCommandBuilder cmdBld = new OleDbCommandBuilder(da1);<br />
            da1.UpdateCommand = cmdBld.GetUpdateCommand();<br />
            @da1.Update(ds1, "db1_table1");<br />
        }