| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass Parameter to Access Query
"Dick Kusleika" wrote in message ...
Remove the parameter from the Access query and rebuild the SQL of the QueryDef object to include the cell's value in the criteria. Alternatively, assuming MS Query, keep the parameters and rebuild the SQL as e.g. EXEC MyStoredProc 'paramter1', 'parameter2' or the ODBC Direct syntax {Call MyStoredProc('paramter1', 'parameter2')} -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pass parameter to access query | Links and Linking in Excel | |||
| Pass date parameter into MS Query | Excel Discussion (Misc queries) | |||
| Is it possible to pass a parameter into IN operator in Query? | Excel Discussion (Misc queries) | |||
| MS query--can it handle parameter queries from Access? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
