Import Excel Tables To SQL Server (Or Any Database) Without A Single Line Of SQL Using Python
Vložit
- čas přidán 4. 09. 2024
- If you are a heavy SQL Server user like myself, which constantly needing to import data from an Excel file to SQL Server, then you will find this video extremely useful. In this video, we will create a very handy Python program to dynamically import tables from an Excel file to SQL Server or any database without writing a single line of SQL statement.
📑 pandas.to_sql Reference: pandas.pydata....
📑 SQLAlchemy data types: docs.sqlalchem...
📑 SQLAlchemy supported databases: docs.sqlalchem...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: CZcams@LearnDataAnalysis.org
#python #sqlserver #database #automation #SQLAlchemy
Great video! How would you identify duplicates from sql and dataframe before appending to sql?
Thanks for sharing, great content. Greetings 👍🏻
Thanks!
Great video! Saved my day!
Splendid
Thank you for the comment.
How did it know where the file was. I did not see you adding a path
By default, the script uses the folder where the file is located.
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
I would suggest try UpWork for help.
I love the video, but call me "lazy", can you post the python script? Thank you
@jie jenn