Product: ImportOmatic

Description: This solution describes how to resolve the Error: Line 1: ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 2. -->System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)-->System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)-->System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)-->System.Data.Odbc.Od
Environment: All

Versions: All

Answer: 

This error occurs when using an excel file for the MasterIDs in Enhanced Appeal/Package Processing. The MasterIDs file need to have the following columns, in this order, with these column headers. It is not required to have values in each column, but the column headers must be present.



For more information on how to use an Excel file for Master IDs, please see this solution.

Refer to the ImportOmatic User Guide for additional information.