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

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