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

[µo°Ý] ADO Select°ÝÃD

¦^´_ 10# »a³·
1.¤£¦Pªº¤u§@ªíÁÙ¬O¥i¥H¥Î¤½¦¡§ì¨ú
=HLOOKUP("2019/12/10",[SQLÄæ¦ì¦WºÙ¬°¤é´Á.xlsm]¤u§@ªí2!C:NC,MATCH("A01",[SQLÄæ¦ì¦WºÙ¬°¤é´Á.xlsm]¤u§@ªí2!$B:$B),FALSE)
¬õ¦r³¡¥÷¬°¸ê®Æ¨Ó·½ÀɮצWºÙ
2.¦pªGÁÙ¬O­n¨Ï¥ÎADO¥u¯à«Øij±N¸ê®ÆTable­×§ï¦¨²Å¦X¸ê®Æ¬[ºcªº®æ¦¡,§_«h¤´·|¹J¨ì¬Û¦P°ÝÃD

TOP

¦^´_ 11# jcchiang


    ¦n¡AÁÂÁ±z¡C
   
   ¬Ý¨Ó¡A§Ú»Ý­n±N¸ê®ÆÀx¦s¤è¦¡§ïÅÜ...¡C

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD