Access中如何用INSERT INTO TABLE1 SELECT * FROM TABLE2
---------------------------------------------------------------
INSERT INTO tb_a ( field )
SELECT tb_b.field
FROM tb_a;
---------------------------------------------------------------
If the structure of table1 is same to table2's,
in acess, U can use as yours:
INSERT INTO TABLE1 SELECT * FROM TABLE2
---------------------------------------------------------------
在进行
INSERT INTO TABLE1 SELECT * FROM TABLE2
时,要求TABLE1和TABLE2的结构要一样。
否则,你就要在两个表中都要写出字段。你试试!