title: Using python to build an sqlite database from multiple csv files
body: <p>I am trying to use Python (Enthought Canopy Editor) to build an sqlite database from csv files.
  I would like to import all csv files contained in a folder into separate tables, with the table name being assigned based on the csv filename.
  So far I have managed to copy and paste chunks of code found online into the following:</p>
  
  <pre><code>import csv
  import sqlite3
  # Create the database
  connection = sqlite3.connect('C:/ROAST/3_ANALYSIS/03_SQL-PY/primo.db')
  cursor = connection.cursor()
  
  # Create the table
  cursor.execute('DROP TABLE IF EXISTS A08')
  cursor.execute('CREATE TABLE  A08 (uno, due, tre) ')
  connection.commit()
  
  # Load the CSV file into CSV reader
  csvfile = open('C:/ROAST/3_ANALYSIS/03_SQL-PY\A08_csv/A08_B1_T5.csv', 'rb')
  creader = csv.reader(csvfile, delimiter=',', quotechar='|')
  
  # Iterate through the CSV reader, inserting values into the database
  for t in creader:
  cursor.execute('INSERT INTO A08 VALUES (?,?,?)', t )
  
  # Close the csv file, commit changes, and close the connection
  csvfile.close()
  connection.commit()
  connection.close()'
  </code></pre>