∟JDBC-ODBC - Creating New Tables in MS Access Database
This section describes how to create a new table in a MS Access database through the JDBC-ODBC driver.
The first test I did was to add another table in my Access database.
This was done by running the CREATE TABLE statement with the executeUpdate() method.
Here is the sample program I used to create a new table called, HY_Addess:
/**
* OdbcAccessCreateTable.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OdbcAccessCreateTable {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:HY_ACCESS");
// Creating a database table
Statement sta = con.createStatement();
int count = sta.executeUpdate(
"CREATE TABLE HY_Address (ID INT, StreetName VARCHAR(20),"
+ " City VARCHAR(20))");
System.out.println("Table created.");
sta.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
The ODBC driver allowed me to create tables and there was no execution errors. See the output below:
