Skip to content

Hiiirad/csv-to-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Importing CSV File to SQL Database!

License PyPI - Status

Hi everybody :)

Getting Started

This program will only works on Linux systems and I believe it would be work perfectly on Macbooks. My OS is Ubuntu 18.04 and I design this program to run on all debian-based linux systems. The installation process will be different if you use other linux distributions.

This program import all data of a CSV file to database. (When I say database, I mean SQL database)

Features

  • Using pyodbc to connect to your database and read every row using csv library and insert them one by one to database.

  • You can see ODBC Documentation

Prerequisites

sudo apt update && sudo apt upgrade -y
sudo apt install git

Installing

I prefer using Anaconda instead of using Pip or PyPI, but you decide which is good for you.

  • Using Pip:
    sudo apt install python3-pip
    pip install pip
    pip install -r requirements.txt
  • Using Anaconda: Installation process is completely documented here.

Upgrading

  • Pip:
    pip install -U pip
  • Anaconda:
    conda update --all

Version check to verify installation

  • Pip:
    pip --version
  • Anaconda:
    conda --version

Usage

https://github.com/Hiiirad/csv-to-database.git
cd csv-to-database/
python csv-to-database.py

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

This project is licensed under the MIT License - see the LICENSE file for details.

About

Import CSV file to SQL database using ODBC

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages