Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel SQL query
Dear all,
I'm trying to add to my Excel spreadsheet a query that goes to the external database (also an Excel file) and of course pulls out certain data. The problem is that the typical query wizzard enables entering as a parameter only fixed value. My question is if it's possible to add as a criteria valule reference link to selected cell in the spreadsheet. In other word to make the query take the parameter form the certain cell in the spreadsheet. Here is an example of condition: ........WHERE (`Sheet1$`.Year=2005) AND (`Sheet1$`.Month=6).......I'd like the 'month' parameter to be taken from the specified cell ....how to do it ? Is it possible in Excel SQL ? Thanks in advance for your help... 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) |