[µo°Ý] ¾ã²z¸ê®Æ§¨¤º¤j¶q¸ê®Æ
- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2014-10-1
- ³Ì«áµn¿ý
- 2019-3-6
|
[µo°Ý] ¾ã²z¸ê®Æ§¨¤º¤j¶q¸ê®Æ
¦U¦ì¤j¤j¦n,¤p§Ì³Ìªñ»Ýn¾ã²z¤@§å¸ê®Æ(©¹«á¤]»Ýn¾ã²z)©Ò¥H¦³¨Ç·Qªk·Q¥ÎVBA¬Ý¯à§_¹ê²{,¦ý¦³¨Ç¥dÃö.....
¥Dn¥Øªº¡G±N즳ªº¸ê®Æ§¨¤ºªº¸ê®Æ »P MS-SQL ¸ê®Æ®w¤º°µ¤ñ¹ï,¦A½Æ»s¶K¤W(©Î°Å¤U¶K¤W)·s«Ø¥ß¦nªº¸ê®Æ§¨¤º.
¨Ò:¦³¤@Ó¸ê®Æ§¨¥sSCAN ¤º¦³¤TÓ¸ê®Æ§¨ ¤À§O¬° A B C , A¸ê®Æ§¨¤º¦³¤@ÓÀÉ®×A12345678.TXT B¸ê®Æ§¨¤º¦³¨âÓÀÉ®×B12345678.TXT»PB87654321.TXT C¸ê®Æ§¨¤º¦³¤@ÓÀÉ®× C12345678.TXT
¨BÆJ¤@¡G§Ú¨Ï¥Î°Ñ¦ÒGBKEE»yªk ±N Àɮ׸ô®| ÀɦWÂ^¨ú¦ÜEXCEL¤º (OK)
¨BÆJ¤G¡G§Ú±NMS-SQL»s§@VIEWªí»PEXCEL³s½u¨ú±o§Ú§Y±Nn²¾°Êªº¦WºÙ ¦p:B12345678 ©M C12345678 (OK)
¨BÆJ¤T¡G»Ýn±N¨BÆJ¤@»P¨BÆJ¤Gªº¸ê®Æ¥ÎLIKE°µ¤ñ¹ï(¦]¬°¹ê»Ú¤Wn°õ¦æªº¸ê®Æ¥i¯à¤£¬O§¹¥þ¤ñ¹ï¨Ò¦pA12345678-1.TXT ¦ý§Ú¸ê®Æ®w¥i¯à¬OA12345678 §Ú§Æ±æ¤]Â^¨ú¥X¨Ó)(¥dÃö)
¨BÆJ¥|¡GÂ^¨ú¥X¨Ó«á쥻¨BÆJ¤@Â^¨ú¥X¨Ó¸ô®|¬°D:\SCAN\B\B12345678.TXT ©MD:\SCAN\C\C12345678.TXT ½Æ»s©Î°Å¤U¨ì D:\SCAN\«Ê¦s¸ê®Æ\B\B12345678.TXT ©M D:\SCAN\«Ê¦s¸ê®Æ\C\C12345678.TXT(¥dÃö)
³o¼Ëªº°µªk¥i¦æ¶Ü?? ¯à§_½Ð±Ð§Ú¨BÆJ¤T©M¥|n«ç»ò¯}Ãö?? ©Î¬O¦³§ó¦nªº¤è¦¡¨ó§U¯à¾ã²zÀÉ®×(Àɮ׬ù¦³¤W¸Uµ§)..... µo°Ý§¹²¦!! |
|
|
|
|
|
|
- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2014-10-1
- ³Ì«áµn¿ý
- 2019-3-6
|
¦^´_ 1# 520iopiop
¦Û¤v¦^ÂФ@¤U¶i«×...¥Ø«e¤ñ¹ï¤w§¹¦¨
³Ñ¤U¨BÆJ¥|n«ç»ò·h²¾??
¥Ø«e¬O¥´ºâ¤À¬° ²{¦³ ©M °h¥ó ¨âÓ¸ê®Æ§¨°Ï¤À
¨Ò¦p1¡GL:\SCAN\APP\R\R12345678\R12345678.TIF ¬°°h¥ó ±NÀÉ«ö½Æ»s¶K¤W(°Å¤U¶K¤W)Åܦ¨ L:\SCAN\°h¥ó\APP\R\R12345678\R12345678.TIF
¨Ò¦p2¡GL:\SCAN\APP\A\A12345678\A12345678.TXT ¬°²{¦³ ±NÀÉ«ö½Æ»s¶K¤W(°Å¤U¶K¤W)Åܦ¨L:\SCAN\²{¦³\APP\A\A12345678\A12345678.TXT |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¥»©«³Ì«á¥Ñ stillfish00 ©ó 2015-3-17 19:12 ½s¿è
¦^´_ 2# 520iopiop - FileCopy source, destination
- ½Æ»s¤@ÓÀɮסC
- ³æ¤¸ ´yz
- source ¥²n¤Þ¼Æ¡A¦¹¬°¦r¦ê¹Bºâ¦¡¡A¥Î¨Óªí¥Ün³Q½Æ»sªºÀɮצWºÙ¡Asource ¥i¥H¥]§t¥Ø¿ý©ÎÀɮק¨¡B¥H¤ÎºÏºÐ¾÷¡C
- destination ¥²n¤Þ¼Æ¡A¦¹¬°¦r¦ê¹Bºâ¦¡¡A¥Î¨Ó«ü©wn½Æ»sªº¥Ø¦aÀɮצWºÙ¡Adestination ¥i¥H¥]§t¥Ø¿ý©ÎÀɮק¨¡B¥H¤ÎºÏºÐ¾÷¡C
- ½Ðª`·N
- ¦pªG§A·Qn¨Ï¥Î FileCopy ³¯z¦¡©ó¤@Ó¤w¶}±ÒªºÀɮסA«h·|µo¥Í¿ù»~¡C
½Æ»s¥N½X ·h²¾¥i¥ÎName |
|
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
|
|
|
|
|