problem:import csv data

Miki Tebeka miki.tebeka at
Tue Sep 13 09:09:59 EDT 2011

.separator (and .import) are not SQL commands but "sqlite3" commands.
You can get the same effect with the following code:

    with open('/tmp/data.csv') as fo:
        reader = csv.reader(fo)
        cur.executemany('INSERT INTO quote VALUES (?, ?, ?, ?, ?, ?, ?)'), reader)

Miki Tebeka <miki.tebeka at>

More information about the Python-list mailing list