File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Access data from MS Excel? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Access data from MS Excel?" Watch "Access data from MS Excel?" New topic
Author

Access data from MS Excel?

Vikrama Sanjeeva
Ranch Hand

Joined: Sep 02, 2001
Posts: 756
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.


Count the flowers of your garden, NOT the leafs which falls away!
Prepare IBM Exam 340 by joining http://groups.yahoo.com/group/IBM340Exam/
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30894
    
158

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Madeswaran Pachiyappan
Greenhorn

Joined: Jun 29, 2004
Posts: 7
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.


Madeswaran P,<br />Chennai,<br />TamilNadu.
Tracey Mary
Greenhorn

Joined: Jul 09, 2004
Posts: 1
Will this work for me? I have Websphere as my app server. Does that matter?

TIA,
Tracey
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30894
    
158

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
 
subject: Access data from MS Excel?