Insert txt

import re
import string,re
import pymssql
:65421',user='use')
,password='Senha,database=banco)
cur = con.cursor()

file=open('b.txt', 'r')
l = []
lista = []
lista2 = []
for line in file:
    line = line.rstrip()
    l = line.split('\n')
    #print(l)
    for line2 in l:
        lista= line2.split('\t')
         #= lista + line2
        #return lista
        if lista[0] != '':
            lista2 = list(tuple(lista))
            #print(lista2[
           # print(lista2[0:7])
            cur.execute("insert into tbl_Volume_rota_ATIVO values(%s,%s,%s,%s,%s,%s,%s)",lista2)
            #con.executemany(stmt,lista2)
            con.commit()