Verified answer

I use this soft to import excel files into mysql database. They give you 30 days trial. It is very simple program and has a great functionality.

http://www.navicat.com/en/products/navicat_mysql/m...

i think of what you're able to do is create an odbc that connects on your excel spreadsheet record so it rather is taken care of basically like a database. carry out a question on it and save the consequence on your Mysql database

Here I am giving one link to explain your problem.

http://www.discussdesk.com/import-excel-file-data-...

http://www.tech-recipes.com/rx/2345/import_csv_fil...

Try this and let me know how it works. You have to save the Excel file as a CSV file.