View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Jack is offline
external usenet poster
 
Posts: 1
Default Using ADO to access another workbook

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.