Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running speed of Micrsoft Query with Multiple parameters
Hi!,
I created a query with eight parameters. When refreshed, the query will obtain the eight parameter values from 8 different linking cells in a worksheet. If I enter a parameter value and leave the rest of 7 cells blank, the running speed is still about the same (as slow) as the case with 8 parameters entered. Normally, a query with only one parameter is very fast. I also have a query with about 50 parameters. It takes a very very long time to run the query, even though only one parameter was entered. With the option to enter from 1 to 8 paramaters, I am wondering if there is any way to make the query run faster when less parameters are entered. Thank you very much! Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running speed of Micrsoft Query with Multiple parameters
Ken
Not really as you are using MSQuery and ODBC so I suspect it is passing all parameters, despite the fact you have only one with a value (The others will be passing null to the parameter collection. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Ken" wrote in message ... Hi!, I created a query with eight parameters. When refreshed, the query will obtain the eight parameter values from 8 different linking cells in a worksheet. If I enter a parameter value and leave the rest of 7 cells blank, the running speed is still about the same (as slow) as the case with 8 parameters entered. Normally, a query with only one parameter is very fast. I also have a query with about 50 parameters. It takes a very very long time to run the query, even though only one parameter was entered. With the option to enter from 1 to 8 paramaters, I am wondering if there is any way to make the query run faster when less parameters are entered. Thank you very much! Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple parameters in MS Query | Excel Discussion (Misc queries) | |||
Cannot get Wildcards in Parameters to work in MS Query/Excel2003 | Excel Discussion (Misc queries) | |||
Query Parameters | Excel Discussion (Misc queries) | |||
Running XY chart labeller using a macro's parameters and arguments. | Charts and Charting in Excel | |||
Help : Using Parameters with External Date Query | Excel Discussion (Misc queries) |