G
gogo
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
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