File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Access data from MS Excel?" Watch "Access data from MS Excel?" New topic

Access data from MS Excel?

Vikrama Sanjeeva
Ranch Hand

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


Count the flowers of your garden, NOT the leafs which falls away!
Prepare IBM Exam 340 by joining
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31808

As suggested in this thread, you should look into ODBC if you really want to use JDBC for this. I would personally prefer POI.

[OCA 8 book] [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

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
I too suggest for POI.

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

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

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31808

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