Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a query to an SQL database that runs through an ODBC link. I want two
parameters pulled form cells filled in by the user to me used as parameters in the query. For example CELL C1= month and F1 = year in external data query ... ...... where month(table.field) = CELL-C1 and year(table.field) = CELL-F1. Can I do this? I've read all about a parameterized query but "parameters" is not enabled for external data. What am I missing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |