Does ucanaccess accept SELECT table.* INTO

[Steven Cooke]

My code looks like this:

PreparedStatement ps = null;

sql = "SELECT tblRequestsFromDWH.* INTO tblTechnique FROM tblRequestsFromDWH WHERE tblRequestsFromDWH.finalBethesda Is Null AND tblRequestsFromDWH.smearTechnique Is Not Null";

ps = module.getSupportConnection().prepareStatement(sql);
ps.execute();

However when I run this I get this exception:

net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.4 unexpected token: INTO required: FROM
However I can run this from within MS Access just fine

[Steven Cooke]

looks like a syntax error

sql = "INSERT INTO table (column1, column2) + " SELECT table2.column1, table2.column2 FROM table.2" + " WHERE some condition exists";

[Gord Thompson]

Answered on Stack Overflow here.