wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Automate Excel Loading into Database" Watch "Automate Excel Loading into Database" New topic
Author

Automate Excel Loading into Database

Ramya Iyer
Ranch Hand

Joined: Jul 29, 2003
Posts: 66
Hi,

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?

Thanks,
Ramya.
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="http://kvrlogs.blogspot.com" 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.

Layne


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?


http://home.arcor.de/hirnstrom/bewerbung
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Automate Excel Loading into Database
 
Similar Threads
display access tabel in excel format
Read data from ExcelSheet
Generate Excel file
Query Regarding Reading Excel files at Runtime
read data from excel sheet and put it into the postgresql database