Skip to content

kippnorcal/csv_to_sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

csv_to_sql

Dynamically load csv file to new ms sql table

Getting Started

Clone to repo

$ git clone https://github.com/kipp-bayarea/csv_to_sql.git

Install dependencies

$ pipenv install

Setup environment variables

$ touch .env

Add the following key value pairs to the .env file:

DB_SERVER=""
DB=""
DB_SCHEMA=""
DB_USER=""
DB_PWD=""

Run the code

$ pipenv run python main.py --filepath <path> --tablename <name>

Be sure to replace and with the filepath and table name and you want to use.

About

Dynamically load csv file to new sql table

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages