Meaningless Drivel is fun!
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: 33119

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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: 33119

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?
It's not a secret anymore!