3 Replies Latest reply on Mar 15, 2012 5:22 AM by 904205

    Error when uploading an Excel -> Too few parameters. Expected 2

    J_ORCL
      Hi everyone,

      I have been able to upload data from excel files succesfully but, now I am encontering some issues to be solved.

      Now I have been sent a new file, with name ranges as predefined! and i mapped this info to two different tables, when doing the upload to one of them it works quite well but in the second one I get and error message "-3010 : 07001 : java.sql.SQLException: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1........."

      The samething happens to me when I do try to upload another excel file, I do get "-3010 : 07001 : java.sql.SQLException: [Microsoft][ODBC Excel Driver] Too few parameters. Expected 2. ....."

      According to the URLs --> http://docs.oracle.com/cd/E21764_01/integrate.1111/e12644/excel.htm
      • Too few parameters. Expected 1.
      You are trying to access an nonexisting column in the Excel spreadsheet.

      But it does exist.

      By the way if i wanna add a filter in excel, just to bring the rows with data should it be like:
      <Column> is not null ????

      Best regards!

      J