I need to upload data in an excel sheet to the database using java.
The database will be oracle.
The excel sheet will be uploaded once in a month by a user using a web application (Spring MVC front end).
The excel sheet will be having thousands of records/rows e.g. around 15000 or more.
Please help/
You can use Apache POI - the Java API for Microsoft Documents for processing the file, and then use plain JDBC for inserting data into your database.
It would be fairly fast, and you can catch all exceptions to alert the user about errors.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With