Python 读取文本文件到sql server

import json
import pymysql
import sqlite3
import re
import pyodbc 
import os   #加载所需模块

sqlconn=pyodbc.connect(DRIVER='{SQL Server}',
                       SERVER='服务器名称',
                       DATABASE='数据库名称')
      #连接数据库
cursor=sqlconn.cursor() #打开游标
cursor.execute("CREATE TABLE hb(\
               id varchar(32) not null,\
               Fnum varchar(32) not null,\
               Csta varchar(255) not null,\
               Ccity varchar(32) ,\
               Dcity varchar(32) ,)\
               ")  #执行SQL语句
f = open('地址\\文件.txt', "r",encoding='utf-8')
while 1:
     lines = f.readline() #按行读取
     if not lines:
         break #当读取所有行结束循环读取
     items = [i for i in lines.split()] #将每一行存为list
     print(items)
     cursor.execute("INSERT INTO hb(id,Fnum,Csta,Ccity,Dcity)VALUES('%s','%s','%s','%s','%s')"%(items[0],items[1],items[2],items[3],items[4]))
     #执行sql语句
cursor.execute("SELECT * FROM hb")  #执行sql语句
queryResult=cursor.fetchall() #查询执行的sql操作
print(queryResult)
sqlconn.commit()  
cursor.close()  #关闭游标
sqlconn.close()  #关闭数据库连接