| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.links,microsoft.public.excel.querydao,microsoft.public.excel.worksheet.functions,microsoft.public.sqlserver.connect
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
