Import Records From CSV File (or any data file) to SQL Server (or any database system) With Python

Jan 3, 2021 | Python | 1 comment

In this Python tutorial, we are going to learn how to import records from a CSV file to Microsoft SQL Server.

The script can also be adapted to import dataset from an Excel file, a text file, or any data file as we will be reading the dataset into a pandas dataframe first. And the database system is not limited to just SQL Server, it can be MySQL, Oracle, or any other database systems. I am using SQL Server because this is the database system I know the best.

Dataset Used: https://data.austintexas.gov/Transportation-and-Mobility/Real-Time-Traffic-Incident-Reports/dx9v-zd7x



Buy Me a Coffee? Your support is much appreciated!

PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn



Source Code


1 Comment

  1. Pauline Gomes
    Pauline Gomes on 2021-04-05 at 12:07 AM

    Hello, Thank you for your really knowledgeable video “Importing Records from CSV File to SQL server” I have 1 question, that is, Can i import XML files too with this source code or I need to add some extra lines for that.
    Thank you

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *