~ import os,sqlite3
con = sqlite3.connect("sqlite_test.db")
cur = con.cursor()
flist = os.listdir("/Users/path/")
for ff in flist:
f = (ff,)
cur.execute('insert into tbl_local (vcpath) values(?)' , f ) # watch out, question-mark. there is no quotation mark
con.commit()
con.close()