Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Microsoft jet database engine and jdbc

 
angel aracena
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Jules
 
angel aracena
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Very much, I'll check that out.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic