select * into temptable from yourTabledrop table yourtableselect * from temptable into yourtable where 1>2如果需原来的数据的话,可以 insert into yourtable(field1, field2,...) select .... from temptable
操作方法是打开Access文件,删除表中所有文件内容,再压缩一下。delete * from table 压缩不知怎么写,谁完成他?
insert into yourtable(field1, field2,...) select .... from temptable
压缩不知怎么写,谁完成他?