sheet-to-sql - output the CREATE TABLE statement for an Excel sheet or CSV file
sheet-to-sql myfile.xls sheet-to-sql myfile.csv --header=2
Number of the sheet to use. Counting starts at 1. Default is 1.
Line in which the column headers are. Counting starts at 1. Default is 1.
Do not convert the headers to something that SQL wants but keep them as they are in the sheet. Default is to convert the headers to something nice.
To install SQL::Type::Guess, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Type::Guess
CPAN shell
perl -MCPAN -e shell install SQL::Type::Guess
For more information on module installation, please visit the detailed CPAN module installation guide.