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?

8 Years
Discussion Span
Last Post by Tyrial

Thanks cgeier

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.