I have another point: (I use DSN) I add records FROM FILE.txt and other case I add TABLES but this do not seem in Access, neither seem to other database driver java files(listing of records)... well? I add like:
public static void main(String [ ] args) {
String fileName = "";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Driver
Connection conn = DriverManager.getConnection
("jdbc

dbc:RedWines");
Statement sttmnt = conn.createStatement( // Scrollable
ResultSet.TYPE_SCROLL_INSENSITIVE, // pointer
ResultSet.CONCUR_READ_ONLY );
if (args.length > 0)
fileName = args[0]; // args[0] from command line
else {
System.out.println("Must supply file name – rerun!");
System.exit(0);
}
// Create a new table. Populate it with records from input file.
sttmnt.executeUpdate("DROP TABLE WINES");
BufferedReader inputFile = new BufferedReader(
new FileReader(fileName + ".txt"));
String recordInput = inputFile.readLine(); // Read 1st rec
String sqlCommand = "CREATE TABLE WINES" +
"(" + recordInput + ")"; // Create SQL command
System.out.println(sqlCommand);
sttmnt.executeUpdate(sqlCommand); // Execute SQL command
while ((recordInput = inputFile.readLine())!= null) // Read
{
sqlCommand = "INSERT INTO WINES " + // Build SQL
"VALUES (" + recordInput + ")"; // statement
System.out.println("SQL statement:" + sqlCommand);
System.out.println("Record Added.");
int result = sttmnt.executeUpdate(sqlCommand); // Execute
} // end of while