This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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

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: 43922
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: import data from excel files to database
jQuery in Action, 3rd edition