Member Avatar for Tyrial

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
  • 158 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by Tyrial
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.