主题：两个外部数据源之间的更新

如果都是sqlserver数据库，就好办。

不然，就要用代码解决，如 http://www.foxtable.com/help/topics/2137.htm

Dim cmd1 As New  SQLCommand
Dim cmd2 As New  SQLCommand
Dim dt1 As DataTable
Dim dt2 As DataTable
Dim sCols() As String = {"列名1", "列名2", "列名3"}
Dim  dCols()  As  String = {"列名A", "列名B", "列名C"}
cmd1.ConnectionName = "1"
cmd2.ConnectionName = "2"
cmd1.CommandText = "S        ELECT * From {员工}"
cmd2.CommandText = "S        ELECT * From {员工}"
dt1 =  cmd1.ExecuteReader()
dt2 =  cmd2.ExecuteReader()

For Each dr As DataRow In dt1.DataRows
    Dim nr As DataRow = dt2.AddNew()
    For i As Integer =0 To sCols.Length -1
        nr(dCols(i)) = dr(sCols(i))
    Next
Next

哦，要这样

dt1 =  cmd1.ExecuteReader(true)
dt2 =  cmd2.ExecuteReader(true)

最后要保存一下的

dt2.Save