File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes import data from excel files to database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "import data from excel files to database" Watch "import data from excel files to database" New topic

import data from excel files to database

efi oikonom

Joined: Apr 03, 2013
Posts: 1
Hi to all,
i am newbie in java. I have created a program to read data from excel files with APACHE POI and show them in my console. I am using Eclipse as editor. Now I an trying to import these data in database so I can store them. The purpose for that is i would like to be able to access them from different locations.
Can someone help me of how I would do this?

Here is my code for import data from excel to database:

And here is my code to read excel file using APACHE POI:

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46429
Welcome to the Ranch
I have added code tags, which you should always use. You can see how much better it looks, at least where you actually indented the code
I agree. Here's the link:
subject: import data from excel files to database
jQuery in Action, 3rd edition