.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)

HTH
--
Miki Tebeka <miki.teb...@gmail.com>
http://pythonwise.blogspot.com
-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to