con = sqlite3.connect('mycorpus.db')
cur = con.cursor()
cur.execute(
    'CREATE TABLE Corpus(sid INT, scid INT, sent TEXT, PRIMARY KEY (sid))')
with open('corpus.tab', 'rb') as input_file:
    reader = unicodecsv.reader(input_file, delimiter='\t')
data = [row for row in reader]
cur.executemany('INSERT INTO Corpus (sid, scid, sent) VALUES (?, ?, ?);', data)
con.commit()
How to put a textfile into sqlite simply using Python API?