"Select * from [Recovered_Sheet1$] where Property='Boston'"

HTH. Best wishes Harald

"Jack" skrev i melding
...
Can someone tell me what query string you use to access an
Excel 2003 workbook from another one.

I think I found the string you would use to get all the
records of an Excel range:

strquery = "Select * from [Recovered_Sheet1$]"

But what is the exact Syntax you would use if you just
wanted certain records? For example, I have a field (from
the first row of the table) called Property. What would
the above string be if I wanted say just all rows that
have "Boston" in this column?

Any help would be appreciated. Thanks.