Using ADO to access another workbook
Thanks to all!!
-----Original Message-----
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.
.
|