title: Error in number of bindings supplied and values supplied
body: <p>I am trying to convert an excel sheet into an sqlite3 db using win32com module in python. My excel sheet has 6 columns and so my a part of my python code is:</p>
  
  <pre><code>for row in exceldata:
        c.execute('INSERT INTO exceltable1 VALUES(?,?,?,?,?,?)',row)
  conn.commit()
  </code></pre>
  
  <p>But python gives me the following error:  </p>
  
  <pre><code>c.execute('INSERT INTO exceltable VALUES(?,?,?,?,?,?)',row)
  ProgrammingError: Incorrect number of bindings supplied. The current statement uses 6, and there are 5 supplied.
  </code></pre>
  
  <p>If I try to remove one question mark and run it again, the error now becomes:  </p>
  
  <pre><code>c.execute('INSERT INTO exceltable1 VALUES(?,?,?,?,?)',row)
  OperationalError: table exceltable1 has 6 columns but 5 values were supplied
  </code></pre>
  
  <p>Could anyone please explain to me whats happening here and if there is any solution...<br>
  Thx.</p>