File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "import data from excel files to database" Watch "import data from excel files to database" New topic
Author

import data from excel files to database

efi oikonom
Greenhorn

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
Sheriff

Joined: Oct 13, 2005
Posts: 40052
    
  28
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: http://aspose.com/file-tools
 
subject: import data from excel files to database