File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access data from MS Excel?

 
Vikrama Sanjeeva
Ranch Hand
Posts: 756
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I don't know whether is it possible or not. Actually the Data of big company [7000 employes] is saved in MS Excel. Now company wants to access this data from web site. This web site will be in JSP/Servlets. Now problem is that, can I make Databse connection between Servelts and MS Excel using JDBC API so that I can access/modify Data from Servelts.
Kindly reply.

Bye,
Viki.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vikrama,
As suggested in this thread, you should look into ODBC if you really want to use JDBC for this. I would personally prefer POI.
 
Madeswaran Pachiyappan
Greenhorn
Posts: 7
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Vikrama,
What Jeanne Boyarsky told is exactly correct...


U can use-- sun.jdbc.odbc.JdbcOdbcDriver() where DSN pointing to Excel.
other wise
Apache giving a excellent package for Manipulation of Excel Data.ie..POI.
I too suggest for POI.
 
Tracey Mary
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Will this work for me? I have Websphere as my app server. Does that matter?

TIA,
Tracey
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tracey,
Both of the options can be used with any app server. One is a 3rd party library and the other is a database driver.

And welcome to Javaranch!
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic