Interested to Buy Any Domain ? << Click Here >> for more details...
give me a java code snippet to connect Microsoft excel
through.... I am trying alot... plz help me.
- 7 Answers
- 18154 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 is CLOB and BLOB datatypes in JDBC?
What is jdbc driver manager?
Why did my jdbc code throw a rollback sqlexception?
What is isolation level? How to set it?
Give steps to connect to the db using jdbc?
What is in term of jdbc a datasource?
What is “dirty read” in JDBC? Which isolation level prevents dirty read?
Why jdbc is used in java?
Is jdbc a web technology?
What is the benefit of having jdbcrowset implementation?
How can we disable a constraint ?
What are the jdbc drivers in java?
Is jdbctemplate thread safe?
Where is jdbc used?
What is a rollback in jdbc?
