Create MySQL table from xls spreadsheet
Question: I wonder if there is a (native) possibility to create a MySQL table from an
.xls or .xlsx spreadsheet. Note that I do not want to import a file into an
existing table with LOAD DATA INFILE or INSERT INTO, but to create the table
from scratch. i.e using the header as columns (with some default field type
e.g. INT) and then insert the data in one step.

So far I used a python script to build a create statement and imported the
file afterwards, but somehow I feel clumsy with that approach.


Answer: There is no native MySQL tool that does this, but the [`MySQL PROCEDURE
ANALYSE`](http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html) might
help you suggest the correct column types.

