直接加上筛选条件,如
Dim filter As String = Tables("表A").Filter
DataTables("表A").Select(iif(filter>"", filter, "1=1") & " and 第二列 = '123456'")