Vul een tabel vanuit Excel

Vul een tabel vanuit Excel 

def runSQL(szSQL):
    import cx_Oracle
    con=cx_Oracle.connect('schema1/pwd@myserver:1521/db1')
    cur=con.cursor()
    cur.execute(szInsert)     
    cur.close()
    con.commit()
    con.close()


import pandas as pd
import numpy as np
#xls_file=pd.ExcelFile('C:\\Users\wagenerj\Documents\Python Scripts\zintest.xlsx')
xls_file=pd.ExcelFile('C:\\Users\wagenerj\Documents\Python Scripts\Factuur_regelstest.xlsx')
df=xls_file.parse('ZorgNed_FactRegl303')

szStart="insert into myTable  VALUES ("
values=""

#methode1 doorlopen waardes in regel
for  index,row in df.iterrows():
        values=""
        for myfield in row:
            values= values + "'" + str(myfield) + "',"
            szInsert=szStart + values
            szInsert=szInsert[:-1] + ")"
        runSQL(szInsert)
#methode 2 doorlopen waardes in regel
#for  index,row in df.iterrows():
#            for t1 in df.iloc[index]:
#                values= values + "'" + str(t1) + "'"