2

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

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418
Steve
  • 23
  • 4

1 Answers1

1

Does UCanAccess accept SELECT table.* INTO ... ?

No. UCanAccess uses HSQLDB for processing SQL statements and HSQLDB uses a different form:

CREATE TABLE tblTechnique (col1, col2, ...) AS (SELECT * FROM tblRequestsFromDWH) WITH DATA;
Gord Thompson
  • 116,920
  • 32
  • 215
  • 418