hi prashant,

Use the following code to insert the data into MS-Access database:

import java.sql.*;
import java.math.*;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;

public class InsertData extends JFrame implements ActionListener {

JButton insertButton;
JTextField text1,text2;
JLabel label1,label2,label;
JPanel p1,p2,p3,panel;

public InsertData(){
insertButton = new JButton("Insert");
insertButton.addActionListener(this);
text1 = new JTextField(15);
text2 = new JTextField(15);

label1 = new JLabel("Name:");
label2 = new JLabel("Address:");
label = new JLabel("",JLabel.CENTER);

p1 = new JPanel();
p2 = new JPanel();
p3 = new JPanel();
panel = new JPanel();
p1.add(insertButton);
p3.add(label);
panel.setLayout(new GridLayout(2,1));
panel.add(p3);
panel.add(p1);

p2.setLayout(new GridLayout(2,1));
p2.add(label1);
p2.add(text1);
p2.add(label2);
p2.add(text2);

this.getContentPane().add(p2,"Center");
this.getContentPane().add(panel,"South");
this.setSize(300,150);
this.show();
}
public static void main(String args[]){
InsertData data = new InsertData();
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==insertButton)
{
PreparedStatement pstm;
ResultSet rs;
String sql;
if((text1.getText().equals("")&&(text2.getText().equals("")))){
label.setText("Please enter the textfields.");
}
else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect =DriverManager.getConnection("jdbc:odbc:access");
pstm=connect.prepareStatement("insert into data values(?,?)");
pstm.setString(1,text1.getText());
pstm.setString(2,text2.getText());
pstm.executeUpdate();
label.setText("Data is inserted into MS Access database");
pstm.close();
connect.close();
}
catch(Exception ex){
System.out.println(ex);
}
}
}
}
}

Thanks