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.
The type assignment is not always accurate, therefore, make sure to check the 'script.sql' to confirm that everything is correct.
The prerequisite programs are:
phyton3
pip3
numpy
panda
xlrd
To run it:
python3 Converter.pyThe excel file should be in the same directory as the Converter.py script.
Every contribution is welcome.