Javatpoint Logo

Insert Data into MySQL database from Excel File using JSP

By: sanket*** On: Fri Apr 29 10:56:12 IST 2016     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
I trying to develop one web application. In that i have to upload Microsoft Excel sheet into mysql database. In that excel sheet there is Table with some information in columns and row format. I am using following link for insertion data:
http://java2career.com/2012/10/insert-data-into-database-from-excel.html

But i have error: Details have not been inserted!!!!!!!!! And where should i save my "testExcel.xls" file in my computer? I am using linux(Fedora 15) operationg system. Now my "testExcel.xls" file is in "/home" location. but this file is not inserting in mysql database. Please help me for this. I am not make any changes in this code. Only i change database name, user name and password in "DB_Connection.java" file. If any changes need tell me.
Up0Down