Question: Batchwise Store
i want to read the column from excel and store the data as batchwise into database
You can read excel file using POI API. After reading the data you can easily save into database using SQL and JDBC.
Read more at Reading And Writing Excel File.
Thank you for your response. Now i came to know how to read the data from excel to database.But i am looking for there is huge data is available in excel insted of reading one line and put into database. i want to store bulk data in database at a time.
Thank you very much