Private Sub CommandButton1_Click()
Dim cnn As Object, SQL$
a = InputBox(" ", , "A1")
Set cnn = CreateObject("ADODB.Connection")
cnn.Open "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.Path & "/基数数据.xls"
SQL$ = "Select * from [Sheet1$] where 姓名 like '" & a & "'" '文本值前后 要加 单引号 , 日期值 前后加 #
[a2].CopyFromRecordset cnn.Execute(SQL)
cnn.Close
Set cnn = Nothing
End Sub