Import Excel Tables To SQL Server (Or Any Database) Without A Single Line Of SQL Using Python

[@Yuya0518]

Great video! How would you identify duplicates from sql and dataframe before appending to sql?

[@lianchi2646]

Great video! Saved my day!

[@tor-code]

Thanks for sharing, great content. Greetings 👍🏻

[@jiejenn]

Thanks!

[@RajashekarBasarveni]

where is the option to pass the TABLE SCHEMA?

[@nanayaw7159]

Splendid

[@jiejenn]

Thank you for the comment.

[@beinggillani]

How did it know where the file was. I did not see you adding a path

[@jiejenn]

By default, the script uses the folder where the file is located.

[@mehuljoshi151]

Hello sir i have excel sheet and in this excel data refresh every 1min. Now my requirement is i want to tranfer all my excel data into sql server without closing my excel sheet and data transfer in every 1min then how to do please let me know

[@jiejenn]

I would suggest try UpWork for help.

[@ws3457]

I love the video, but call me "lazy", can you post the python script? Thank you

[@AnujVerma-kp3md]

@jie jenn