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
 
Ad

Advertisements

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
 
Ad

Advertisements

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
 

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

Top