ODBC Access sriver error

B

Belinda7237

I have a query linked to a worksheet in excel - i added a field to the query
and when i went to refresh the worksheet to add the additional field I got an
error -

Miscrosoft ODBC Access Driver Too few parameters . Expected 1.

Does anyone know how to resolve?
 
C

Chris O'C via AccessMonster.com

Delete the link to the worksheet and recreate it.

The reason you're getting this error message is that the link info doesn't
change after you create the link, even if the linked table does. Your query
expects a field that wasn't in the original link.

Chris
 
Top