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
- 17922 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 jndi lookup?
How can you make the connection using jdbc?
How to use JDBC API to call Stored Procedures?
What is jdbc and explain jdbc architecture?
Describe the steps needed to execute a sql query using jdbc.
Which database is used for java?
How many ways that we can view a result set?
Why should we close database connections in java?
Explain what should be done when a SQL exception is raised?
What are the different types of interfaces in the api component?
How do I find whether a parameter exists in the request object?
What is JDBC PreparedStatement?
Explain the importance of drivermanager.
Is jdbc faster than hibernate?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
