Adding new values to a table in MS Access

[Matthew Gaunt]

Hi There,
Am using a MS Access database to hold data, and want to add to one of the tables using JDBC.
Under most circustances, this is not a problem.
The question is, how do I add data to a table which has an AutoNumber field as the primary key??
Best Regards
Matt Gaunt

[bill bozeman]

I haven't tried it with JDBC, but the SQL Statement would look something like this:

INSERT INTO table_name(column2, column3, etc...) VALUES (value1, value2, etc....)

Since you have an autonumber, you have to list all of the fields that are going to be inserted. You don't include the autonumber since, well it is auto.
Bill