How to Connect to an Excel Spreadsheet using JDBC in Java?

1.	How to Connect to an Excel Spreadsheet using JDBC in Java?
Answer» Follow the steps below First setup the new ODBC datasource. Goto Administrative Tools−>Data Sources (ODBC)−>System DSN tab−>Add−>Driver do Microsoft Excel(.xls)−>Finish. Now give the Data Source Name (SampleExcel) & Description. Next, click Select Workbook and point to your excel sheet. In the code make to following code additions Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection conn = DriverManager.getConnection("jdbcodbcSampleExcel","","");stmt = conn.createStatement();sql = "select from [Sheet1$]";rs=stmt.executeQuery(sql); Where Sheet1 is the excel sheet name.

Answer»

Follow the steps below

First setup the new ODBC datasource. Goto Administrative Tools−>Data Sources (ODBC)−>System DSN tab−>Add−>Driver do Microsoft Excel(*.xls)−>Finish. Now give the Data Source Name (SampleExcel) & Description. Next, click Select Workbook and point to your excel sheet.

In the code make to following code additions

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection conn = DriverManager.getConnection("jdbcodbcSampleExcel","","");stmt = conn.createStatement();sql = "select * from [Sheet1$]";rs=stmt.executeQuery(sql);

Where Sheet1 is the excel sheet name.

Discussion

No Comment Found

Related InterviewSolutions

What is difference between JDBC, JNDI and Hibernate?
How to Connect to an Excel Spreadsheet using JDBC in Java?
What is Metadata and why should you use it?
Which isolation level prevents dirty read in JDBC, connection class?
What is a "dirty read"?
What are different types of RowSet objects?
What is a RowSet?
What we set the attribute Concurrency in ResultSet?
When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement?
What does the Class.forName("MyClass") do?

How to Connect to an Excel Spreadsheet using JDBC in Java?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment