Upload Excel File Data To MS SQL Server Using Python (Source Code In Description)

[@chaoticninja3711]

Thanks a lot, this simple video helped me with issues i was having for a good while

[@jhajibuganas]

Hi, Thanks for your video. How to upload if the table is not yet created? how to create the table within the python file using sqlalchemy?

[@ambikeshprajapati680]

I want to insert the complete data in one hit for that reason I am using method =“multi” but it is throwing error while the same script runs good for mysql but fails in mssql. Can you help me with the issue?

[@areafiftyonecfgosproject1288]

I have followed every step and still I got an error: Can't open lib 'SQL Server' : file not found". Help 🙏🏽🙏🏽🙏🏽

[@abdullahmusheer4238]

how can i automate this process to grab this file everyday and update the database everyday?thanks

[@jiejenn]

You can use task scheduler

[@Yuya0518]

Great video! Would you recommend this same method for an online excel file say on sharePoint?

[@jiejenn]

Don't know if I can help since I don't have any experience working with SharePoint.

[@imran01111]

Why you use pypyodbc not pyodbc

[@jiejenn]

For some reason my PC run into errors when I use pyodbc.

[@rajkumarrajan8059]

i got an error in line 18 pypyodbc is not defined what should i do?

[@jiejenn]

Define your pypyodbc object?

[@edwinnugroho5707]

hello, thankyou for your video, but why i got this error code from SQLAlchemy import create_engine ModuleNotFoundError: No module named 'SQLAlchemy'

[@jiejenn]

The error is clearly stating SQLAlchemy is not installed or cannot be found.