EZ
я делаю insert через for, таким образом:
for index, row in final_df.iterrows():
cursor.execute("INSERT INTO dbo.MDLP( [SeriesNumber], [CountCodeMark], [Status], [DateRegInRegistry], [NameOrganization], [Inn], [FIAS], [CountCodeMarkInStatus], [TotalArrived], [TotalLeft], [Balance], [DateLoadFile], [lat], [long]) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
int(row['SeriesNumber']),
int(row['CountCodeMark']),
str(row['Status']),
str(row['DateRegInRegistry']),
str(row['NameOrganization']),
int(row['Inn']),
str(row['FIAS']),
int(row['CountCodeMarkInStatus']),
int(row['TotalArrived']),
int(row['TotalLeft']),
int(row['Balance']),
str(row['DateLoadFile']),
str(row['lat']),
str(row['long']),
)
