| 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
|
|
 |
|
|
subject: Automate Excel Loading into Database
|
|
|
0
