exceltosqlserver 0.2.5

This package help convert your excel files (xlsx,xls,csv) to SQL Server Database.

Introduction

This package help to convert your excel files (xlsx,xls,csv) to SQL Server database.

Installation

exceltosqlserver can be installed as:

pip install exceltosqlserver

Dependency

👍 pandas

👍 pyodbc

👍 sqlalchemy

QuickStart

from exceltosqlserver import ExcelToDB, hostname, local_ip

# STEP One, prepare your input pareameters

yourFile  = "test01.xls"  # available for xlsx, xls,csv
yourUsrID = ""
yourPWD   = ""
yourDBname= ""
rename_table = ""  # Use your filename as tablename onto SQL Server or user define the table name, e.g. :"test"

# get your local host name
# this will return your local computer name for your sql server database
host_name = hostname

# get your local ip address
# this will return your local ip address (if your sql server can be accessed by DNS)
ip = local_ip

# you need to change your host if needed, dns: local ip address
#yourHostORip  = "localhost"
# yourHostORip  = host_name
yourHostORip  = ip


# STEP Two add your data to sql server
es = ExcelToDB(yourFile, yourHostORip, yourUsrID, yourPWD, yourDBname, rename_table)
es.save2db()

output:
Successfully load excel data...
Sucessfully connected to SQL Server...
Sucessfully saved 'yourtable' to SQL Server...

API Reference

exceltosqlserver.ExcelToDB(filePath,host_ip=False,usrID =False,pwd=False,db_name=False,rename_table)

filePath: str

host_ip: str default: ""

usrID: str default: ""

pwd: str default: ""

db_name: str default: ""

rename_table: str default: "", will auto save your filename as table name to sql server database. If assignmed value, will change table name from your filename to the assigned value.