This project is to build a nice to use, robust tool to generate SQL from the structure of an Excel sheet so it becomes easy to port excel sheets to a RDBMS.
As of now, 1.0 is in a raw format and needs Java 1.7 to run.
To run, just download the jar into any new folder, copy your excel sheets to convert and run "java com.kannan.sqlator.ui.Sqlatorcli --file <<your excel="" file="" name="">>. You should see another file with same name, but with .sql for you to create the table and also with import data.
The file should have only one worksheet and the first row (only) must have the column labels. All other rows in the worksheet will be considered data rows.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As of now, 1.0 is in a raw format and needs Java 1.7 to run.
To run, just download the jar into any new folder, copy your excel sheets to convert and run "java com.kannan.sqlator.ui.Sqlatorcli --file <<your excel="" file="" name="">>. You should see another file with same name, but with .sql for you to create the table and also with import data.
The file should have only one worksheet and the first row (only) must have the column labels. All other rows in the worksheet will be considered data rows.