Variable SQL Statements pulling from a cell in Excel
Well, Ardus
That's something I hadn't stumbled on before and find it very helpful
Thanks
"Ardus Petus" wrote:
Use :
SELECT * FROM TABLE WHERE YEAR = ?
Close Microsoft Query and get back to Excel
In popup window, select Parameters...
HTH
--
AP
"Preacher Man" <nospam a écrit dans le message de
...
I have a situation that I hope someone can give me a good answer to.
Please
bear with me as I try to explain my needs.
My goal is to have an Excel spreadsheet that pulls from a SQL database and
the the query pulls from a variable in the Excel sheet. For example let's
say I am pulling Sales Orders from SQL, let's also simply assume the
record
has two fields Year and SOno.
Under a simple query I could say Select * from table. Of course that
would
pull all so's from every year.
To filter the query of course I could say Select * from table where
year='2006'. And naturally that would give me 2006 orders.
OK, here's where I can't figure this out. I want the query to filter
according to a value in a cell in excel. Let's use cell A1. Essentially
I
am looking for a query that says "Select * from table where Year=(Cell A1
in
the Sheet)"
Is this possible?
|