How to connect to d/b which is present in excel or any spread sheet application using jdbc. I was able to establish a connection using the Type1 driver, but I was unable to extract(select) the data from the excel sheet.

Showing Answers 1 - 2 of 2 Answers

samar jain

  • Jan 18th, 2007
 

We can use JDBC type 4 driver to connect to excel sheet or spread sheets. Just search  for "HXTT" ODBC driver. Use this driver.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions