Hi All,
Does anyone know how to update records in an Excel file using
JDBC. This is what I did
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc
dbc:Excel","","");
Statement st = con.createStatement();
String sql = "INSERT INTO sheet1$ VALUES ('Preeti', 'Chopra' )";
st.executeUpdate(sql);
st.close();
con.close();
but the system throws the following exception
Message SQLException = [Microsoft][ODBC Excel Driver] Syntax error in INSERT INTO statement.
However, the code works perfectly when used with MSAccess.
Can anybody give any idea please???
Regards
Preeti