sSql := 'select * into ouform from ouform in [ODBC][ODBC;Driver={Microsoft ODBC for Oracle};UID=bklskf;PWD=bklskf;SERVER=bkls;]';注意数据类型匹配的问题,最好将字段名全部标明错了,上面是新建表,应为Insert
Insert Into ouform 字段 select 字段 from ouform [ODBC][ODBC;Driver={Microsoft ODBC for Oracle};UID=bklskf;PWD=bklskf;SERVER=bkls;]';
'select * into ouform from ouform in [ODBC][ODBC;Driver={Microsoft ODBC for Oracle};UID=bklskf;PWD=bklskf;SERVER=bkls;]';注意数据类型匹配的问题,最好将字段名全部标明错了,上面是新建表,应为Insert
变成几十兆了,不知道是怎么回事啊?我是先把Access的表的数据删除之后,再导入数据的,删除的数据量跟导入的数据量是一样的,照理说
数据库文件不应该变这么大的?
//压缩与修复数据库,覆盖源文件
var
JE:OleVariant;
ConnStr,DBPath:String; Dao: OLEVariant;
begin
DBPath:=ExtractFilePath(Application.ExeName);
JE:=CreateOleObject('DAO.DBEngine.36');
JE.CompactDatabase(DBPath+'/BAk.mdb',DBPath+'/new.mdb');
DeleteFile(PAnsiChar(DBPath+'/BAk.mdb'));
RenameFile(PAnsiChar(DBPath+'/new.mdb'),PAnsiChar('BAk.mdb'));
end;