give me a java code snippet to connect Microsoft excel
through.... I am trying alot... plz help me.

Answer Posted / m.gangadhar

hi create DSN for Microsoft Excel(.xsl) in
controlpanel/administrativetools/datasources

after that write normal code for driver class and getting
connection Object.

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is drivermanager in jdbc?

721


What does jdbc setmaxrows method do?

698


What are different parts of a url?

690


What are collection pools?

701


How do you determine the sensitivity of the ResultSet object?

742


Explain the locking system in jdbc?

720


What is a statement?

748


Jdbc-odbc bridge is multi-threaded or not?

715


List the common jdbc exceptions ?

774


Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

796


Which database is used for java?

712


How we store procedure in oralce for callable statements in jdbc

2049


There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

813


What is a jdbc connection string?

638


How do I find ojdbc jar version?

675