I use Microsoft Access 2000 Database,I create a table named test,it contains one column named col1,it's type is number.
then I use statement like follows:

String str="insert test(col1) values(1)";
...
stmt.executeUpdate(str);

When I run it,it raise error:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO statement grammer error.

But if column's type is Text,I use str="insert test(col1) values('1')"; it can run success.Why I can't insert number type value in Access 2000?

How to insert into number value in Access 2000?

I do not use the same syntax for updating records, so I am not 100% sure. I noticed that your first example was missing the de-limiting characters '1'.

A more likely problem is your data type, your database is expecting a number, you are inserting a string. Try using a prepared statement:

st = conn.prepareStatement("UPDATE test SET col1 = ?");

st.setInt(1,yourInt);
st.executeUpdate();
st.clearParameters();

Sorry, incorrect code:

st = conn.prepareStatement("INSERT INTO test (col1) VALUES (?)");

st.setInt(1,yourInt);

st.executeUpdate();
st.clearParameters();

ur problem is that command has syntax error ie.
 insert into test(col1) values(1).

try it .ok
all the best

P.Mallikharjuna Rao