title: pyodbc INSERT INTO from a list
body: <p>I am trying to insert data into an Access mdb file using a list as the source for the values. </p>
  
  <pre><code>cursor.execute("select * from Components")
  cursor.executemany("""
                    INSERT INTO Components
                    ([Database Number],Description, [Warehouse Code],[Supplier Code], Usage, Major1, Minor1)
                    VALUES (?,?,?,?,?,?,?)
                    """), input_list
  cursor.commit()
  </code></pre>
  
  <p>I get the error "TypeError: function takes exactly 2 arguments (1 given)".  The error refers to the line """), input_list</p>
  
  <p>What I am I doing wrong?  Thanks in advance for your help.</p>
  
  <p>Here is a print of the input_list</p>
  
  <pre><code>['7', '1/2"  PVC 90° Elbow', '406-005', 'SUP2', 'Y', 'PVC FS', 'PVC FS']
  ['7', '3/4"  PVC 90° Elbow', '406-007', 'SUP2', 'Y', 'PVC FS', 'PVC FS']
  ['7', '1"  PVC 90° Elbow', '406-010', 'SUP2', 'Y', 'PVC FS', 'PVC FS']
  ['7', '1.25"  PVC 90° Elbow', '406-012', 'SUP2', 'Y', 'PVC FS', 'PVC FS']
  ['7', '1.5"  PVC 90° Elbow', '406-015', 'SUP2', 'Y', 'PVC FS', 'PVC FS']
  ['7', '2"  PVC 90° Elbow', '406-020', 'SUP2', 'Y', 'PVC FS', 'PVC FS']
  </code></pre>