太平洋来的风

//从外数据库插入到本数据库表中
//追加式
INSERT INTO tbl_bbb
SELECT *
FROM tbl_aaa IN 'C:\a b c d\AAA.mdb';

//覆盖式
SELECT * INTO bbb
FROM tbl_aaa IN 'C:\AAA.mdb';

//本数据库查询外数据库内容
SELECT * FROM tbl_aaa IN 'C:\AAA.mdb';

//由本数据库插入到外数据库表中数据
SELECT * INTO tbl_aaa in "C:\BBB.mdb"
FROM tbl_aaa

insert INTO tbl_aaa (xm,xb) IN 'C:\BBB.mdb' select xm,xb FROM tbl_aaa;