GeeCON Prague 2014*
The moose likes JDBC and the fly likes Adding new values to a table in MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Adding new values to a table in MS Access" Watch "Adding new values to a table in MS Access" New topic
Author

Adding new values to a table in MS Access

Matthew Gaunt
Greenhorn

Joined: Mar 12, 2001
Posts: 12
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
Ranch Hand

Joined: Jun 30, 2000
Posts: 1070
I haven't tried it with JDBC, but the SQL Statement would look something like this:

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Adding new values to a table in MS Access