import sqlalchemy as sa
import os
import time
import pyodbc
import pandas as pd
import urllib
server =
database =
username =
password =
conn = pyodbc.connect(DRIVER='{SQL Server Native Client 11.0}', SERVER=server,
                        DATABASE=database, UID=username, PWD=password)
params = urllib.parse.quote("DRIVER={SQL Server Native Client 11.0};SERVER=server;DATABASE=db;UID=user;PWD=pwd")
engine = sa.create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)
df.to_sql("test_table",engine,if_exists="append",chunksize=100,index=False)