OleDbConnection oconn = new OleDbConnection(strConn);
            try
            {
                oconn.Open();
                OleDbDataAdapter da = new OleDbDataAdapter("Select * from [" + tables[0] + "]", oconn);
                da.Fill(dt);
            }
            catch { return false; }
            finally { oconn.Close(); }

using (SqlConnection sqlConn = new SqlConnection("connectingstring"))
                {
                    SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn);
                    bulkCopy.DestinationTableName = "dbo.Test";
                    sqlConn.Open();
                    bulkCopy.WriteToServer(dt);  // dt - DataTable
                    sqlConn.Close();
                }