Insertion in MS EXCEL

[suraj sheikh]

[code]
import java.io.*;
import java.sql.*;
public class MyExcel {
public static void main(String[] args) {
Connection connection = null;
String str="HELLO";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection( "jdbcdbc:MYDSN" );
Statement st=con.createStatement();
st.executeUpdate("INSERT INTO [Sheet1$] VALUES ('Suraj','sheikh')");
con.close();
} catch(Exception exec) {
exec.printStackTrace();
}
}
}
[/code/

The above code writes data only in the first column of every row, I want to write multiple colums in a single row

PLEASE HELP

Thanks in advance

[Jeanne Boyarsky]

Originally posted by suraj sheikh:
The above code writes data only in the first column of every row, I want to write multiple colums in a single row

How about using Java to figure out what values should go in each row and pass them to the select?