Hi Friend,

We have created a table Table2(name(Text),cl(Number),marks(Number),rollNo(Number)) in MS access database.

Try the following code:

import java.sql.*;
public class Insert {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:access");
Statement st = con.createStatement();
int c = st.executeUpdate("INSERT INTO Table2(name,cl,marks,rollNo) VALUES( 'Naman',3,78,1105)");
System.out.println("1 row affected");
st.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}

Thanks