aspose file tools
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
Author

connect to microsoft excel db driver

pavansatya venkata
Greenhorn

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.
Regards
Pavan
[ August 11, 2007: Message edited by: Bear Bibeault ]
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6662
    
    5

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.

mohan


mohan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connect to microsoft excel db driver