Too few parameters

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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...
 
Back
Top