Too few parameters

N

Nuno Bento

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
 
N

Nuno Bento

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
[email protected]
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...
 
Top