After the extraction of data, it saves to an excel file. I would like it to save in MySQL database instead of the excel file.
Platform used: Eclipse, MySQL
Take the 2-minute tour
×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
|
|
To implement this , you need to have 2 JAR FILES that are APACHE-POI and mysql-connector. First, to fetch data from excel file , you need to use APACHE-POI library. And as you get data row by row , insert data into mysql table using mysql-connector jar file. It will be easy if the Structure of the excel file is same as table in MYSQL. |
|||||
|
|
You can achieve this functionality By using Apache POI and mysql connector you can also check JexcelAPI and JXL. as @vicky said maintaining the structure of your excel same as database table will make your job easy and that way you will get less errors comparatively. |
|||||||||
|
