I am trying to set up the URL for Windows as in the manual but I get a error mesaage.
I have my excel file in this path: C:\Data.xls. I defined the URL connection as below:
jdbc:excel:///c:/Data.xls
Am I rigth or there is another way to set it up?
Kind Regards,
H��ctor Pantoja
|
Your jdbc url is correct. What's your error message? Whether you haven't called Class.forName("com.hxtt.sql.excel.ExcelDriver");
|
You can use
catch(java.sql.SQLException sqle ){
do{
System.out.println(sqle.getMessage());
System.out.println("Error Code:"+sqle.getErrorCode());
System.out.println("SQL State:"+sqle.getSQLState());
sqle.printStackTrace();
}while((sqle=sqle.getNextException())!=null);
}
|