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
Describe the steps needed to execute a sql query using jdbc.
Why do I have to reaccess the database for Array, Blob, and Clob data?
How do I stop nullpointerexception?
Explain the steps in writing a java program using jdbc?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
Explain the difference between rowset vs. Resultset in jdbc?
Under what circumstances, that all four drivers are used?
What does the jdbc databasemetadata interface?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
Define preparedstatement.
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
Give an example for execution of sql statement.
What is a statement?
How can I get information about foreign keys used in a table?
What is the function of drivermanager class?