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

[µo°Ý] ¾ã²z¸ê®Æ§¨¤º¤j¶q¸ê®Æ

[µo°Ý] ¾ã²z¸ê®Æ§¨¤º¤j¶q¸ê®Æ

¦U¦ì¤j¤j¦n,¤p§Ì³Ìªñ»Ý­n¾ã²z¤@§å¸ê®Æ(©¹«á¤]»Ý­n¾ã²z)©Ò¥H¦³¨Ç·Qªk·Q¥ÎVBA¬Ý¯à§_¹ê²{,¦ý¦³¨Ç¥dÃö.....

¥D­n¥Øªº¡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±N­n²¾°Êªº¦WºÙ ¦p:B12345678 ©M C12345678 (OK)
¨BÆJ¤T¡G»Ý­n±N¨BÆJ¤@»P¨BÆJ¤Gªº¸ê®Æ¥ÎLIKE°µ¤ñ¹ï(¦]¬°¹ê»Ú¤W­n°õ¦æªº¸ê®Æ¥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°Ý§¹²¦!!

¦^´_ 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

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2015-3-17 19:12 ½s¿è

¦^´_ 2# 520iopiop
  1. FileCopy source, destination
  2. ½Æ»s¤@­ÓÀɮסC

  3. ³æ¤¸ ´y­z
  4. source ¥²­n¤Þ¼Æ¡A¦¹¬°¦r¦ê¹Bºâ¦¡¡A¥Î¨Óªí¥Ü­n³Q½Æ»sªºÀɮצWºÙ¡Asource ¥i¥H¥]§t¥Ø¿ý©ÎÀɮק¨¡B¥H¤ÎºÏºÐ¾÷¡C
  5. destination ¥²­n¤Þ¼Æ¡A¦¹¬°¦r¦ê¹Bºâ¦¡¡A¥Î¨Ó«ü©w­n½Æ»sªº¥Ø¦aÀɮצWºÙ¡Adestination ¥i¥H¥]§t¥Ø¿ý©ÎÀɮק¨¡B¥H¤ÎºÏºÐ¾÷¡C

  6. ½Ðª`·N
  7. ¦pªG§A·Q­n¨Ï¥Î 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

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD