参考:http://www.foxtable.com/webhelp/topics/0400.htm、http://www.foxtable.com/webhelp/topics/1533.htm
Dim drs As List(Of DataRow) = DataTables("表A").Select("第二列 like '%zz%' or 第二列 like '%HH%' and 第一列 not like '%tt%'")
For Each dr As DataRow In drs
Dim dr2 As DataRow = DataTables("表B").AddNew()
For Each dc As DataCol In DataTables("表A").DataCols
dr2(dc.Name) = dr(dc.name)
Next
dr.Delete
Next