insert into tablename
select * from bablename in '其它数据库的路径'
例:
'insert into b2 select a,b from b1 in ''C:/Documents and Settings/Administrator/桌面/sss/test1.mdb'''
insert into tablename
select * from bablename in '其它数据库的路径'
例:
'insert into b2 select a,b from b1 in ''C:/Documents and Settings/Administrator/桌面/sss/test1.mdb'''