Too few parameters

G

Guest

Hi,

I set up some pivot tables in Excel to pull information in from MS Access
queries.

Pivots worked fine, but when I went to refresh them, I got the "[ODBC
Microsoft Access Driver] Too Few Parameters. Expected 2" error message.

Does anyone know why this error occurred on refresh?

Regards
Nuno
 
S

Simon Murphy

Nuno
Are your Access queries complex?
The ODBC driver can't cope with UNIONs and some other stuff
Not sure why it would work once, but not refresh though. Any changes to
the queries or db or paths?

Cheers
Simon
Blog: www.smurfonspreadsheets.net
 
G

Guest

Thanks guys. I'll try and simplify the query.

Nuno

Nick Hodge said:
Nuno

As Simon points out the ODBC driver coughs on complex queries. I suspect you
have a parameterised query that is expecting two parameters

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog



Nuno Bento said:
Hi,

I set up some pivot tables in Excel to pull information in from MS Access
queries.

Pivots worked fine, but when I went to refresh them, I got the "[ODBC
Microsoft Access Driver] Too Few Parameters. Expected 2" error message.

Does anyone know why this error occurred on refresh?

Regards
Nuno
Click to expand...
Click to expand...
 

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

MS Excel Error: Too many client tasks 1
too few parameters 1
Too few parameters error with a IIF statement 5
Work laptop issues 4
Too few parameters 2
pivot table getting empty set of data from Access 2
MS Query Wizard 1
Too few parameters. Expected 2 1

Top