give me a java code snippet to connect Microsoft excel
through.... I am trying alot... plz help me.
- 7 Answers
- 16763 Views
- I also Faced
- E-Mail Answers
Answer Posted / sushant
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myDB = "jdbc:odbc:Driver={Microsoft Excel Driver
(*.xls)};DBQ=c:/java/scratch/jdbc_test.xls;"
+ "DriverID=22;READONLY=false";
Connection conn = DriverManager.getConnection(myDB, "", "");
| Is This Answer Correct ? | 19 Yes | 6 No |
Post New Answer View All Answers
What happens if connection is not closed in jdbc?
Can we return resultset in java?
Explain the necessary steps to connect to the database in java?
Which is better odbc or jdbc?
What is the role of jdbc drivermanager class?
How can you know about drivers and database information ?
Explain Basic Steps in Writing a Java Program Using Jdbc?
What are the differences between execute, executequery, and executeupdate?
How do you determine the sensitivity of the ResultSet object?
Which package is used for jdbc application?
What is in terms of jdbc a datasource?
What is jdbc odbc?
What is jdbc architecture in java?
What is encrypted connection?
What is jdbc template?
