Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL query in Excel - help !
I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet. The problem I faced is that I don't know what value needs to be put into the cell in order to select all values for given parameter in the examlpe below this would be "Country" and "Product". I tried many things but none of them works e.g. "*" ..........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?) Thanks a milion for someone who know a simple solution. Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |