Sub GetQuery()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & ActiveWorkbook.Path & "\" & ActiveWorkbook.Name & ";" & _
"Extended Properties=Excel 8.0;"
.Open
End With
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.ActiveConnection = cn
'Create sql string
sql_str = "select * from [sheet2$] where field1='condition'"
rs.Open sql_str
Sheets(1).CopyFromRecordset rs
rs.Close
cn.Close
End Sub