ªð¦^¦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 : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD