The mysql command line is prone to too many problems on import. Here is how you do it:
- use excel to edit the header names to have no spaces
- save as .csv
- use free Navicat Lite Sql Browser to import and auto create a new table (give it a name)
- open the new table insert a primary auto number column for ID
- change the type of the columns as desired.
- done!