importing data from excel sheet into oracle table

There are two options

1. try to use SQL*Loader utility.

2. Make JDBC ODBC connection to Excel file and use JDBC queries to read and store data to database. The name of first row columns are used as table columns. The java code example for this is posted below,

Connection con= null;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con= DriverManager.getConnection("jdbc:odbc:GC", "", "");

Statement stmt= con.createStatement();

ResultSet rs= stmt.executeQuery("select username, password from userlogin");

while (rs.next())

{

String lname = rs.getString(1);

String fname = rs.getString(2);

System.out.println(fname + " " + lname);

}

rs.close();

System.out.println(con.isClosed());

stmt.close();

}

finally

{

if (con != null)

con.close();

}

abhishekpandey_y2ka at 2007-7-12 16:24:05 >