title: Python - insert into ms access table
body: <p>I am able get some data from the ms access by some query, but I am not able to store data into any table, for example: </p>
  
  <pre><code>import sys, os, pyodbc
  
  conn_str = (
      r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'
      r'DBQ=C:/Users/vlcek/Desktop/pokusdb.accdb;'
      )
  connection = pyodbc.connect(conn_str)
  
  
  cursor = connection.cursor()
  
  sql="Insert into people (user_id, Name, Surname) values (27, 'Peter','Jackson')"
  
  cursor.execute(sql)
  </code></pre>
  
  <p>I do have the table "people" already in database...</p>
  
  <p>I am getting this output, I don't know, if it relevant: </p>
  
  <p>The thread 'MainThread' (0x30e4) has exited with code 0 (0x0).</p>
  
  <p>The program '[9696] python.exe' has exited with code 0 (0x0).</p>
  
  <p>Thank you for your help,</p>
  
  <p>Vaclav</p>