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.org/docs/reference/api/pandas.DataFrame.to_sql.html
📑 SQLAlchemy data types: docs.sqlalchemy.org/en/20/core/types.html
📑 SQLAlchemy supported databases: docs.sqlalchemy.org/en/20/core/engines.html#supported-databases
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ 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: www.linkedin.com/in/jiejenn/
🌳 Becoming a Patreon supporter: www.patreon.com/JieJenn
✉️ Business Inquiring: RU-vid@LearnDataAnalysis.org
#python #sqlserver #database #automation #SQLAlchemy
6 апр 2023
