Q:

Auto Import Excel into phpmyadmin

I want to import excel sheet into database through a web page.
For example- Admin can import the excel sheet into database like uploading a simple file.
I have searched throughout the stack overflow but unable to find any solution.
Please suggest some solution.

A:

The possible solutions are:

Convert your excel file into CSV format. You can easily parse this Comma separated ASCII file using any server side scripting language such as PHP, JSP etc. and prepare appropriate queries to insert these fileds in the database.
If you dont want to convert the Excel file to CSV then u need to use some APIs like Apache POI and Java Servlet/JSP programming clubbed with JDBC to put your data in the database.

