title: how do i insert without inputting all column names with pyodbc execute many?
body: <p>I am trying to insert my data into my ms access sql connection. How do I write an insert statement where I do not have to input all the column names and "?" values. </p>
  
  <p>For example from <a href="https://code.google.com/p/pyodbc/wiki/Cursor" rel="nofollow">https://code.google.com/p/pyodbc/wiki/Cursor</a> :</p>
  
  <p>Executes the same SQL statement for each set of parameters. seq_of_parameters is a sequence of sequences.</p>
  
  <pre><code>params = [ ('A', 1), ('B', 2) ]
  executemany("insert into t(name, id) values (?, ?)", params)
  </code></pre>
  
  <p>This will execute the SQL statement twice, once with ('A', 1) and once with ('B', 2).</p>
  
  <p>I have a table with 22+ columns and i do not want to write "t(names,id,..etc)" and "values (?,?,...,?). I just want to be able to throw in my parameters without doing that. Any suggestions?</p>