my dog learned polymorphism*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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.
It is sorta covered in the JavaRanch Style Guide.
subject: Microsoft jet database engine and jdbc
Similar Threads
Newbie problem. JDBC Error
I want to know how to use hibernate with Ms Access database
Data source name not found and no default driver specified
I'm being forced to ...arg!... run a windoze app ...arg!... that needs M$ Access ...arg!