File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
Similar Threads
how to move to previous record
MSACCESS Connection
Ms-Access with Java Studio creator ?
Get index of a row
How to insert records in ms-access table using jdbc console application.