Dim Cols1() As String = {"来源列一","来源列二","来源列三"} Dim Cols2() As String = {"接收列一","接收列二","接收列三"} For i As Integer = 0 To Tables("表A").Rows.Count - 1 Dim dr1 As Row = Tables("表A").Rows(i) Dim dr2 As Row = Tables("临时表").AddNew() For i As Integer = 0 To Cols1.Length -1 dr2(Cols2(i)) = dr1(Cols1(i)) Next Next