import-csv-into-database

Python script to import csv file into database (MSSQL)

Requirement

pip install pyodbc

On Windows, you may be prompted to install "Microsoft Visual C++ 14.0". This can be resolved by installing the "Build Tools for Visual Studio".

The configuration file (settings.py) needs to be modified according to the environment.
.xlsx file must be converted to the .csv file

git clone https://github.com/shichikoromo/import-csv-into-database.git
python script.py

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
resources		resources
README.md		README.md
script.py		script.py
settings.py		settings.py