Skip to content
+1-888-319-3663

COMMUNITY FORUM

ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.

Dean asked 6 years ago
When using Microsoft 2010 odbc connection to a spreadsheet, its throwing this error:
 
ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
 
Please advise
 
Thanks
 
Dean
 
Answers
patrick answered 6 years ago
Dean,
That means something is wrong with your ODBC query.  There doesn’t seem to be a specific reason for this error message -search the web with your favorite search tool for the error you are getting and you’ll see.
Only thing I can suggest is to simply your query or since it is an Excel file instead use “Excel 2013” as the source and not ODBC and it should work fine.

If you would like to submit an answer or comment, please sign in to the eOne portal.