update main A,(select T_id,T_update,T_fav from historytable in ""[MS Access;PWD=12345;DATABASE=F:"Test"localdb.mdb;]) B set A.T_fav=B.T_fav, A.T_update=B.T_update where A.id=B.T_Maindb_id;
支持各种数据库,详见ms access帮助
转载于:https://www.cnblogs.com/celika/archive/2008/04/08/1141916.html