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
- 17871 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 are the differences between resultset and rowset?
How can we maintain the integrity of a database by using jdbc?
What is database deadlock ?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
Why resultset is used in java?
Does jdbctemplate use prepared statements?
What is difference between jdbc and odbc?
Does sql allow null values ? Can we use it within where clause ?
What is JDBC API and when do we use it?
What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?
Is jdbc a framework?
What is represented by the connection object?
What is an escape syntax?
What is the difference between jdbc and jndi?
What is namedparameterjdbctemplate?
