Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
access cell in other workbook | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Access values from another workbook | Excel Programming | |||
Can't access to a WorkBook | Excel Programming | |||
Can't access to a Workbook | Excel Programming |