This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Microsoft jet database engine and jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Microsoft jet database engine and jdbc" Watch "Microsoft jet database engine and jdbc" New topic

Microsoft jet database engine and jdbc

angel aracena

Joined: Aug 30, 2004
Posts: 3
Have somebody solve the problem with jdbc and microsoft jet engine.
I have an app that reads an excel file, it was working fine until I upgrade office 2000 to 2003. then I started getting the message: "Exception: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'comissTable2'. Make sure the object exists and that you spell its name and the path name correctly."
I've done everything, updated the jet engine and much more, also search the web for answers and nothing. can somebody give me a hand with this problem. I try to use POI from Jakarta but for my project is too much work and it wont work the way is suppose to. any help or suggestions will be very welcome.
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
Hi Angel,

Welcome to JavaRanch!

I don't know anything specific about your problem, but the error you're reporting is an ODBC error, not a JDBC error. Can you connect to the ODBC datasource and access that table without using Java? If so then perhaps it's the bridge driver you need to update???

I doubt I can be of any more help than that.

angel aracena

Joined: Aug 30, 2004
Posts: 3
Thank you Very much, I'll check that out.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Microsoft jet database engine and jdbc
It's not a secret anymore!