Skip to content

This is a python script that convert excel table content to SQL query.

License

Notifications You must be signed in to change notification settings

amad1101/Excel_to_SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 

Repository files navigation

Excel_to_SQL

This program convert excel files to SQL queries and add them into to sql ready file called 'script.sql'. It automaticaly check the value of each column and based on their format, decide the type of the column.

As Notice

The type assignment is not always accurate, therefore, make sure to check the 'script.sql' to confirm that everything is correct.

prerequisite

The prerequisite programs are:

phyton3
pip3
numpy
panda
xlrd

To run it:

python3 Converter.py

Important

The excel file should be in the same directory as the Converter.py script.

Contributing

Every contribution is welcome.

About

This is a python script that convert excel table content to SQL query.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages