直接使用SQL操作Access没有问题,使用Access_JDBC30.jar出错!
使用Access_JDBC30.jar,想在Access中用旧表建新表,
String sql = "SELECT * into AllJudge FROM Judge1";
stat.execute(sql); //也用过stat.executeQuery(sql)
出现如下错误:
Exception in thread "main" java.sql.SQLException: Select Grammar Error: SELECT column list must correspond to into-variable list, but you had missed 6 column-identifier.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
这是怎么回事?
说明一下,我在Access中直接操作没有问题。