Sub 查询()
Dim i, sql$, Cnn As Object, rs As Object
Set Cnn =CreateObject("ADODB.Connection")
Cnn.Open"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &ThisWorkbook.FullName _
& ";ExtendedProperties=""Excel 12.0;HDR=yes;IMEX=1"";"""
sql = "select * from [sheet1$] where 职位 like '[经理人]%'"
Set rs = Cnn.Execute(sql)
ar = Cnn.Execute(sql).GetRows '写入数组
With Sheet2
.Cells.Clear
For i = 0 To rs.Fields.Count - 1
.Cells(1, i + 1) =rs.Fields(i).Name
Next
For i = 0 To UBound(ar)
For j = 0 To UBound(ar, 2)
If i = 3 Then k = Format(ar(i,j), "yyyy/m/d") Else k = ar(i, j)
.Cells(j + 2, i + 1) = k
Next
Next
End With
Set rn = Range("A1:F" &Cells(Rows.Count, 1).End(3).Row): rn.Select
ActiveSheet.ListObjects.Add(xlSrcRange, rn,, xlYes).Name = "表1"
Range("G1").Select
End Sub