Running speed of Micrsoft Query with Multiple parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query 4
Parameter Query Won't Run 0
Excel Query setup 0
Multiple parameters in MS Query 1
Query Parameter using multiple options 0
Query problem 2
MS Query - 2 Parameters 2
Parameter query troubleshooting: Empty cell issue 1

Back
Top