ODBC and Windows 7

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

[cgeier]

Probably need to install "2007 Office System Driver".
See http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en . That is if you are using the 2007 version.

Other things you may want to look at are:
http://www.connectionstrings.com

http://support.microsoft.com/kb/247412

MS .NET Framework 3.5 SP1
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ab99342f-5d1a-413d-8319-81da479ab0d7

ODBC .NET Provider
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6ccd8427-1017-4f33-a062-d165078e32b1

Jet 4.0 SP8 (32-bit)
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156

Jet 4.0 SP8 (64-bit)
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ad2b6698-de73-47dc-911b-50f4f0627ff4

MDAC Checker
http://support.microsoft.com/kb/301202

MDAC 2.8 SP1
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=78cac895-efc2-4f8e-a9e0-3a1afbd5922e

MS SQL Server JDBC Driver 2.0
http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en

[Tyrial]

Thanks cgeier

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