Access±íÊý¾ÝºÏ²¢

¼ÙÉèÓÐÎļþ  E:\a.mdb; F:\b.mdb

a.mdb:
±íÃû: First
Êý¾ÝΪ:
ÐÕÃû,µØÖ·,ºÅÂë
a,a11,a12
a,a12,a13
b,cs,as
¡­¡­

b.mdb:
±íÃ÷:First
Êý¾ÝΪ:
ÐÕÃû,µØÖ·,ºÅÂë
c,a11,a12
a,a12,a13
b,e3,as
¡­¡­

µÚÒ»²½ÊÇÏë:
½«Êý¾Ýa.mdbÀïÃæ±ífirstÊý¾Ý¿½±´µ½b.mdbµÄ±ífirstÖÐÇÒÒÔÐÕÃûÖØÐÂÅÅÁÐ.ÆäÖÐÈçÓÐÊý¾ÝÖظ´µÄÔò²»¿½±´.¼´µÃµ½ÈçÏÂÊý¾Ý:
a,a11,a12
b,cs,as
c,a11,a12
a,a12,a13
b,e3,as
¡­¡­

ÆäÖÐ Êý¾Ý:a,a12,a13Öظ´£¬ËùÒÔûÓп½±´¡£

ÔÚÍøÉÏ¿´µ½: insert into Óï¾äÄܹ»ºÏ²¢±í
µ«Îҵõ½µÄ½á¹ûÊÇ: ½«a.mdbÀïÃæµÄÊý¾Ý¿½±´2´Îµ½b.mdb±ífirstÖÐ:

c,a11,a12
a,a12,a13
b,e3,as
a,a11,a12
a,a12,a13
b,cs,as
a,a11,a12
a,a12,a13
b,cs,as¡­¡­

²»ÖªµÀÓï¾äÓÃ´í»¹ÊÇ£¿
ÄÜ·ñÌṩһ¸öÀý×Ӳο¼²Î¿¼ÄØ£¿Ð»Ð»

---

Äã¿ÉÒÔÔÚ×Ö¶ÎÉÏÏÞÖÆΪ²»Öظ´£¬È»ºóÑ­»·´¦Àíѽ
µ±²åÈëÊý¾Ý³ö´íʱ£¬ËµÃ÷¾ÍÓÐÖظ´µÄÊý¾ÝÁË£¬×÷¸ö´íÎóÏÝÚå¾Í¿ÉÒÔÌø¹ýÕâ¸ö´íÎó

---

ÓÐûÓÐÓï¾ä²Î¿¼°¢¡£¡£

---

insert into ¿ÉÒÔ½â¾ö,¿´ÄãµÄÕâ¾äÔõôдµÄ

---

ÈçºÎ×öµ½ºÏ²¢µÄ½ø¶ÈÄØ£¬ÎÒ¿ÉÒÔÖªµÀfirstÀïÃæµÄÊý¾ÝÁ¿×ÜÊý£¬ÈçºÎÖªµÀËûÒѾ­ºÏ²¢Á˶àÉÙÄØ£¿

---

н¨Ò»¸öCÊý¾Ý¿â£¨¸´ÖÆAÊý¾Ý¿âµÄ¾Í¿ÉÒÔÁË£©£¬AÊý¾Ý¿âµÄµÚÒ»Ìõ¼Ç¼ÓëBÊý¾Ý¿âµÄÄÚÈݱȽϣ¬°ÑËüµÄÐÕÃûÓëBÊý¾Ý¿âµÄÿ¸öÒ»ÐÕÃû×ö±È½Ï£¬Èç¹ûûÓÐÒ»ÑùµÄ¾Í°ÑËü¸øCÊý¾Ý¿â¡­¡­¡­¡­¡­¡­

---

ÒýÓÃ

SQL codeinsertinto[;da