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.
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???