import sqlite3 import codecs db = sqlite3.connect('iTunes/iTunesLibrary.db') curs = db.cursor() with codecs.open('tracks.txt', 'r', 'utf-8') as fp: for track in fp: curs.execute('insert into filesystem(location) values(?)', (track.strip(),)) db.commit()