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 connect to microsoft excel db driver 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 "connect to microsoft excel db driver" Watch "connect to microsoft excel db driver" New topic

connect to microsoft excel db driver

pavansatya venkata

Joined: Aug 10, 2007
Posts: 1
hi friends

i have some problem when making a connection to microsoft excel database driver from the java bean. Could any one provide me the code how to establish the connection.

Thanks in advance.
[ August 11, 2007: Message edited by: Bear Bibeault ]
Deepak Bala

Joined: Feb 24, 2006
Posts: 6662

What does this have to do with JSP ? Probably belongs in the JDBC forum ? What errors are you facing ?

SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
mohan kumar r
Ranch Hand

Joined: Jan 19, 2006
Posts: 38
add mirosoft excel driver and create data source
control panel>adminstrative tools>Datasources.
remaing code is same as connecting to oracale or some other DB but table name is the name of work sheet with a $ appended to the end.


I agree. Here's the link:
subject: connect to microsoft excel db driver
It's not a secret anymore!