ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤u§@±Æµ{automail¡G¡uª«¥ó¨Ã¥¼¦^À³¥ô¦ó°T®§¡A³o¥i¯à¬O¦]¬°¨Ó·½À³¥Îµ{¦¡¥¿¦b¦£¸L¡v

[µo°Ý] ¤u§@±Æµ{automail¡G¡uª«¥ó¨Ã¥¼¦^À³¥ô¦ó°T®§¡A³o¥i¯à¬O¦]¬°¨Ó·½À³¥Îµ{¦¡¥¿¦b¦£¸L¡v

¦U¦ì¤j¤j­Ì¦n¡G

¤p©f¼g¤F¤@­Ó¥¨¶°¡A·f°t¤u§@±Æµ{(Windows Server 2008)©w®Éautomail¡A
¥¨¶°¤º®e¡G¥DÀÉ(¬¡­¶Ã¯A)¨Ì§Ç¶}±Ò«ü©wªºÀÉ®×(¬¡­¶Ã¯B¡BC...)¡A¨Ã°õ¦æ(¬¡­¶Ã¯B¡BC...)ªº¥¨¶°
±Æµ{³]©w¡G¥u¦³¨Ï¥ÎªÌµn¤J®É¤~°õ¦æ+¥H³Ì°ªÅv­­°õ¦æ
°õ¦æÀô¹Ò¡GWindows 7¡A»P¥L¤H¦@¦Pªº¹q¸£¡F¤½¥q¹q¸£·|¥ð¯v¡A¦³³]©w¯S©w±b¸¹¦Û°Êµn¤J°õ¦æ

¦Û¤v´ú¸Õ°õ¦æ¥i¶¶§Q§¹¦¨¡A¦ý±¾¦b¤u§@±Æµ{«o®É±`¥X²{¤U¦C¿ù»~°T®§¡G
¡uª«¥ó¨Ã¥¼¦^À³¥ô¦ó°T®§¡A³o¥i¯à¬O¦]¬°¨Ó·½À³¥Îµ{¦¡¥¿¦b¦£¸L¡v<<google·j´M¦ü¥G¥¼¯à¸Ñµª¦¹°ÝÃD(key word¿ù¤F¡H)


·Ð½Ð¦³¸gÅ窺¤j¤jµ¹¤©«ü±Ð¡A«D±`·PÁ¡I

Dear ¤j¤j­Ì¡G

¸É¥R»¡©ú¡G¤W­±©Ò´y­zªº¦Û°Ê¤Æ¡A§Ñ°O»¡¨ä¤¤¤@­ÓÀô¸`¬O¥ÎQueryTable¬d¸ßDB¸ê®Æ¡A
(1)µo²{°õ¦æ¨ì¦¹³Bµ{¦¡´N·|¤¤Â_(±¾¦b¤u§@±Æµ{°õ¦æ®É)¡A·Pı¦n¹³¬OQueryTableª«¥ó©M¨ä¥¦ª«¥ó¤¬¬Û¤zÂZ¡H
(2)¤]µo²{°¸º¸·|¦³"µ¥«Ý¬d¸ß"ªº°T®§¥X²{¡A¬OBackgroundQuery:=Falseªº½t¬G¶Ü¡H
§Ú°Ñ¾\¤F¤U¦C¸ê®Æ¡G
https://support.office.com/zh-tw/article/%E6%9B%B4%E6%96%B0%E9%80%A3%E7%B7%9A-%E5%8C%AF%E5%85%A5-%E7%9A%84%E8%B3%87%E6%96%99-e76a38b0-e2e1-400b-9f2f-c87b9b18c092

¥Ñ©óQueryTable¤p©f¸û¤£¼ô±x¡A«á¨Ó§ï¥ÎADO¬d¸ß(«Dª«¥ó)¡A©ú¦­·|±oª¾´ú¸Õµ²ªG...
(1) & (2)¤p©fªºÆ[©À­Y¦³¿ù»~¡A¦A³Â·Ð°ª¤â«ü¥¿»P«ü¾É¡A·PÁ¡I

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD