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 2 phase commit?

564


What is a statement?

577


How can you know about drivers and database information ?

549


How to test jdbc connection to sql server?

503


What are the three basic components of the odbc architecture?

469






Explain the two tier and three tier architecture of jdbc.

524


In which ways is driver class is registered with drive manager?

526


What is metadata in jdbc?

486


How to insert and delete a row programmatically? (new feature in JDBC 2.0)

532


When do we get java.sql.SQLException: No suitable driver found?

545


How to retrieve warnings in jdbc?

526


Is jdbc secure?

513


Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?

487


What are the considerations for deciding on transaction boundaries?

559


Write an sql to find all records having all numeric characters in a field ?

492