Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull parameter from worksheet for External Data Query to SQL Datab
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |