title: SQLite Python Insert - Incorrect Number of Bindings Supplied
body: <p>apologies if this is redundant, I spent a good deal of time trying to find the answer but none of the tricks supplied seemed to do anything. I am trying to use Python to read into SQLite a csv document of stock data (yahoo finance): </p>
  
  <pre><code>Ticker  Open    High   Low    Close  Volume  AdjClose  
  AA      1/5/11  16.34  16.59  16.11  16.56   48278700  16.56
  </code></pre>
  
  <p>I am using the following commends:</p>
  
  <pre><code>to_db = [(i['Ticker'], i['Open'], i['High'], i['Low'],i['Close'], i['Volume'], i['AdjClose']) for i in dr]
  c.executemany("insert into stock_test1 (Ticker, Date, Open, High, Low, Close, Volume, AdjClose) values ( ?, ?, ?, ?, ?, ?, ?, ?);", to_db)
  </code></pre>
  
  <p>and I get:</p>
  
  <p>sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 8, and there are 7 supplied.</p>
  
  <p>Where am I going wrong on this?</p>