• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Automate Excel Loading into Database

 
Ramya Iyer
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Layne Lund
Ranch Hand
Posts: 3061
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Perhaps it is possible, to save the excel-file as csv?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic