Access 資料新增到不同資料庫，或查詢不同資料庫的資料

INSERT INTO [;database=C:\Users\s\Desktop\Access\data2.mdb].table3 ( txt1, txt2, txt3 )
SELECT txt1, txt2, txt3
FROM table1;

SELECT *FROM table3 IN "" [;database=C:\Users\s\Desktop\Access\data2.mdb];

database前需加分號[;database=....]
database需用絕對路徑 EX：C:\Users\s\Desktop\Access\data2.mdb