Can anyone see a Syntax error in the following INSERT statement? INSERT INTO tblGenericDate (systemID, boundBy, from, to, considerLast, calculateWhen) VALUES (24, 'calendarYear', 0, 0, 2, 'quarterly') The error is: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Padraig There is nothing wrong with the syntax of the statement although there might be some underlying problem. Try t find out some more about the error: System.out.println(e.getSQLState()); System.out.println(e.getErrorCode()); System.out.println(e.getMessage()); You could have a column name spelled wrong or be trying to insert the wrong type of data into a column. It might be looking for a semi-colon at the end of the statement too (depending on the DB).