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?