2 Replies - 1903 Views - Last Post: 19 January 2010 - 06:52 PM Rate Topic: -----

#1 Supriya88  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 19-January 10

Reading excel files in database using java

Post icon  Posted 19 January 2010 - 11:20 AM

Hi! I want to store the data in MS-Excel file to Database(PostgreSQL) using java. I've tried for poi api but no direct way to store in database, even I've tried it using jdbc-odbc bridge but in that case we have to change the settings of the that particular pc using control panel whereas the requirement is that the application which I'm developing should be portable.
Can anybody please suggest me a good solution? I'm in dire need of that! Thanks in advance
:mellow:

Is This A Good Question/Topic? 0
  • +

Replies To: Reading excel files in database using java

#2 NeoTifa  Icon User is offline

  • Whorediot
  • member icon





Reputation: 2586
  • View blog
  • Posts: 15,618
  • Joined: 24-September 08

Re: Reading excel files in database using java

Posted 19 January 2010 - 11:53 AM

Actually, your best bet would be VBA. I'm supposed to know how to do this by heart, but I don't :( I fail at work.
Was This Post Helpful? 0
  • +
  • -

#3 pbl  Icon User is offline

  • There is nothing you can't do with a JTable
  • member icon

Reputation: 8324
  • View blog
  • Posts: 31,857
  • Joined: 06-March 08

Re: Reading excel files in database using java

Posted 19 January 2010 - 06:52 PM

JExcelApi (just Google for it) will allow you to read an Excel spreadsheet from Java
then you can populate your database accordingly
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1