Error Message- [ODC Microsoft Access Driver]Too few Parameters. Expected 52

[rohitjain]

Hi All,

while updating a pivot table in excel 2007 from MS Access 2007 by using connection parameters I get the error message- [ODC Microsoft Access Driver]Too few Parameters. Expected 52

it would be of great help if any one can help me on this.

[Stingaway]

Check the data source in the pivot table and the data source form Access, make sure that the data elements expected are the same (both column and row). Make sure that the data is refreshed as well once you re-populate it.