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!