give me a java code snippet to connect Microsoft excel
through.... I am trying alot... plz help me.
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 the use of dialect?
Is jdbctemplate thread safe?
What driver should I use for scalable Oracle JDBC applications?
What are the differences between execute, executequery, and executeupdate?
What is CLOB and BLOB datatypes in JDBC?
Explain how to make updates to the updatable resultsets.
How can we retrieve the file in the oracle database?
What are the different types of interfaces in the api component?
Is jdbc object oriented?
How does a custom RowSetReader get called from a CachedRowSet?
What is the use of setFetchSize() and setMaxRows() methods in Statement?
What is meant by jdbc?
What is jdbc connection?
What is an advantage of using the jdbc connection pool?
How do I find whether a parameter exists in the request object?