'复制选定行:
With Tables("表A")
For i As Integer = .BottomRow To .TopRow Step -1
Dim r1 As Row = .Rows(i)
Dim r2 As Row = Tables("表B").AddNew
For Each c As Col In .Cols
r2(c.name) = r1(c.name)
Next
r1.Delete()
Next
End With
'复制所有行:
With Tables("表A")
For i As Integer = .Rows.Count -1 To 0 Step -1
Dim r1 As Row = .Rows(i)
Dim r2 As Row = Tables("表B").AddNew
For Each c As Col In .Cols
r2(c.name) = r1(c.name)
Next
r1.Delete
Next
End With