0

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?

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by Tyrial
0

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.