File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Automate Excel Loading into Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Automate Excel Loading into Database" Watch "Automate Excel Loading into Database" New topic

Automate Excel Loading into Database

Ramya Iyer
Ranch Hand

Joined: Jul 29, 2003
Posts: 66

I have an excel sheet, I need to do some manipulation of the data contained in excel before I load it in the database. I am thinking of automating it.

How do i go about it? Which is the best way to do it?

Venkatraman Kandaswamy
Ranch Hand

Joined: Jul 07, 2004
Posts: 120
Look at jakarta POI - you can read excel files, massage the data and then send to database.
[ May 10, 2005: Message edited by: Venkatraman Kandaswamy ]

--Venkatraman<br />SCJP 1.4<br /><a href="" target="_blank" rel="nofollow">blog</a>
Layne Lund
Ranch Hand

Joined: Dec 06, 2001
Posts: 3061
As much as I hate to say it, it would probably be easier to do this with Visual Basic or possibly C#. I say this because VB integrates with Excel and databases (via ODBC) very easily. As much as I love Java, I strongly believe in using the right tool for the job. In this case, VB seems like a better choice than Java.


Java API Documentation
The Java Tutorial
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

Perhaps it is possible, to save the excel-file as csv?
I agree. Here's the link:
subject: Automate Excel Loading into Database
It's not a secret anymore!