import pymssql
conn = pymssql.connect(host='SQL01', user='user', password='password',
    database='mydatabase')
cur = conn.cursor()
wildcards = ','.join(['?'] * len(frame.columns))
data = [tuple(x) for x in frame.values]
table_name = 'Table'
cur.executemany('INSERT INTO %s VALUES(%s)' % (table_name, wildcards), data)
conn.commit()
Can I export a Python Pandas dataframe to MS SQL?