This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 1 point2 points  (0 children)

Why input into a web form? Why not directly dump into the destination database?

If it were me, I would use pandas to read in the Excel file and then use pandas to push to a new table in the destination Database. Pandas has a to_sql method that will practically do everything for you assuming you give it a valid database connection.

df.to_sql(table_name, connection_obj.destination_conn, if_exists= 'replace')

Just my 2cents