p.raviprasad
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
1 Answer(s)      2 years and 3 months ago
Posted in : Java Beginners

sir.. i have number of excel sheets which contains id, name, subject and marks of several students.. i have to provide a browse button which can upload a excelfile and after uploading the data should be inserted into oracle database.. please help me sir...

Advertisement
View Answers

February 16, 2013 at 3:22 PM


hi friend,

Please go through the following links may this will be helpful for you. However, in these examples MySQL is used as database system if you want to use the Oracle then you can change the JDBC Driver and the url according to Oracle.

http://www.roseindia.net/answers/viewqa/JSP-Servlet/28123-write-excel-file-into-the-oracle-database.html

http://www.roseindia.net/tutorial/java/poi/insertExcelFileData.html

http://www.roseindia.net/tutorial/java/poi/readExcelFile.html










Related Tutorials/Questions & Answers:
Advertisements