xls2mysql is a small windows standalone application that creates a table from Excel file’s name, creating columns from cell values in the first row. Of course this is the kind of task you can perform easily via database administration tools, but the point here is to enhance productivity of Excel TO Mysql data conversion.

The application performs various tasks on Excel file load :

• Excel reader : loads your excel file, parses sheets and displays records
  
• Mysql statement builder :

• sanitize file name for table name
  
•  builds SQL create table statement out of first row (sanitize column names)
  
•  builds sql insert statements out of rows 1..N
  
•  creates SQL file for Mysql