I need to access the information in an excel file, my only problem is, all the forums i read use the ODBC bridge via the data source tool buillt into windows. Since i am running windows 7, i can only assume, i get an error such as the setup routines could not be found for the ODBC driver, plz re-install the driver. thought i could get around this by using the following code:

String myDB = "jdbc:odbc:Driver={Microsoft Excel Driver            (*.xls)};DBQ=StreamData.xls";
conn = DriverManager.getConnection(myDB, "", "");

using this however gives me a null pointer exception. but it works with access. I am a student, but accessing the info is not the task, just using it for a genetic algorithm is. can anybody help?

Thanks cgeier

Those links really helped and will definately use them in the future aswell.

This article has been dead for over six months. Start a new discussion instead.