Hi Friend,

You can use double data type in place of float. To store the double value in Access database, you need to set the datatype 'Number' to both the fields and change the Field Size of both the fields to 'double' from Field Properties.

Here is an example:

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class Test extends JFrame{
public static void main(String[]args){

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1 =DriverManager.getConnection("jdbc:odbc:access","","");
Statement stmt=con1.createStatement();
double marks=80.58;
double percent=80.58;
int i=stmt.executeUpdate("insert into student(marks,percentage) values("+marks+","+percent+")");
JOptionPane.showMessageDialog(null,"Data is successfully inserted into database.");
con1.close();
}
catch(Exception e){
System.out.println(e);
}
}
}

Thanks