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

[µo°Ý] excel vba (´¡¤J¸ê®Æ)insert ¶i sqlite ½wºC°ÝÃD

¦^´_ 20# koshi0413


  §Ú¨S¦³«Ü²`¤Jªº¬Ý±z²Ó¸`ªºµ{¦¡½X
¦ý¥Ø«e¥u¦³¬Ý¨ì¨â­Ó¦a¤è¥i¥Hµy·L§Ö¤@ÂI,§A¥i¥H¸Õ¸Õ¬Ý³o­Ó³¡¤À

²Ä¤@:za=RNG(J,I)  =>³o­Ó³¡¤À¥i¥H¤£¥Î,¥u±µ§â©Ò¦³ªºza¨ú¥N¬°RNG(J,I)§Y¥i=>¦ý³o­Ó¦a¤è¼vÅT¤£¤j
²Ä¤G:±zªº°j°é¤§¤º¨Ï¥Î¤F¤j¶qªºSPLIT,À³¸Ó¦b°j°é¶}©lªº®É­Ôª½±µ±NAR=Split(za, "/")
µM«áIF AR(0)=1 OR LEN(AR(1))=1 THEN
³o¼Ëªº¸Üµ{¦¡´N¤£¥Î¨C¤@¦æ³£°õ¦æ¤@¦¸©î¶}ªº°Ê§@
¥H¤W±z¸Õ¸Õ¬Ý
PKKO

TOP

¦^´_ 21# PKKO

ÁÂÁÂp¤j«üÂI¡A¤U¬P´Á¥X®t¤j³°®É¡A¨Ó¸Õ¶]~~¨ì®É¦b¦^³ø

¤£¹L±z»¡ªº­×§ï²Ä¤GÂI¡A¤j»\¬Ù8¬í§a¡A³o¼ËÁÙ¬O­n70¬í¡A­Ó¤Hıªº¨S¹D²z@@

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD