It is also possible to connect to a spreadsheet without using DSN, which provides a more flexible way within code to point JDBC at an Excel file of interest without the accesses to a client registry to define the required DSN. Without DSN, the db connection is created as following, please not the difference of constructed JDBC URL:
java.sql.DriverManager.getConnection( "jdbc:odbc:Driver={Microsoft Excel Driver
(*.xls)};DBQ=C:/Documents and Settings/myPath/Desktop/qa.xls");
Here DBQ defines the path to the target spreadsheet file (qa.xls). Both backslash and forward slash work well.
Source: Available source
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…