wood burning stoves 2.0*
The moose likes JDBC and the fly likes Exception - To connect  excel  sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exception - To connect  excel  sheet" Watch "Exception - To connect  excel  sheet" New topic

Exception - To connect excel sheet

bala kumar

Joined: Sep 13, 2007
Posts: 10
i got the following error when i get the data from XL sheet to store the data into oracle db in LINUX .

String path = "/home/nfsmnt/resource_uploads/web_links/"+fileName;
connection = DriverManager.getConnection("jdbcdbcriver={Microsoft Excel Driver (*.xls)};DBQ="+path+";DriverID=22;READONLY=false","","");
Statement stmt = connection.createStatement();


java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.thomsonhighereducation.DAO.ResourceOrderDAO.addWeblinkData(ResourceOrderDAO.java:2239) at
Don't get me started about those stupid light bulbs.
subject: Exception - To connect excel sheet
Similar Threads
Connectting to MS Access in Remote machine without DSN
Connecting To Database
how to connect ms acess in java
[ODBC] Connection not Open
Data source name not found and no default driver specified