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

[­ì³Ð] ¤W¥«Âd¤T¤jªk¤H¶R½æ¶W¤é³ø¸ê®Æ·J¾ã³B²z

[­ì³Ð] ¤W¥«Âd¤T¤jªk¤H¶R½æ¶W¤é³ø¸ê®Æ·J¾ã³B²z

³o¬O¤p§Ì§Ú°µªº¤W¥«Âd¤T¤jªk¤H¶R½æ¶W¤é³ø¸ê®Æ·J¾ã
¤£¹L»Ý­n¨C¤Ñ¥hÃÒ¥æ©Ò©MÂd¶R¤¤¤ß¤U¸ü¶R½æ¶W¤é³ø©M½L«áªº»ù®æ¸ê®Æ(¦³¤H¥i¥H§ï¼g¦Û°Ê¤U¸ü¥\¯à¨Ã¤À¨Éªº¸Ü¡A¤p§Ì§Ú±N¤­Åé§ë¦a¨ØªA¦Ü·¥xD)
¨Ò¦p:¤WÂdªk¤H¶R½æ¶WªºÀɦW¬OSQUO*......
§å¶q¶×¤J©Î³æ¤é§ó·sªº¸ê®Æ§¨¦ì¸m¤]­n¦Û¦æ¥h¬Ý§Úªºµ{¦¡½X°µ§ó§ïxD
¤£¹L³o¬O¥b¦¨«~¡A©Ò¥HÁٻݭn¤j®aªº¬Ã¶Q·N¨£¡A¥ô¦ó¯àÅýµ{¦¡¥[³t©Î§ó¦h¥\¯àªº¤èªk¤§Ãþªº...¤p§ÌÁÙ­n¦h¸òª©¤W°ª¤â¾Ç²ß^^
¶i¤@¨Bªº¸ê®Æ¤ÀªR¥\¯àÁÙ¨S°µ¡A¥u¦³°µÂ²³æªº´ú¸Õ¥\¯à
1.ªk¤H³s¶R´X¤é
2.ªk¤H°Ï¶¡¤º¶R¶W¤Ñ¼Æ¹F´X¤é¥H¤W...
¤j®a´N¦Û¦æµo´§³Ð·N§ïµ{¦¡½X¦A¤W¨Ó¤À¨Éµ¹§a~~~
·PÁ¦U¦ì°ª¤â¬°§Ú¸Ñ´b¡A¦b¦¹±N¤p§Ìªº·s¤â§@«~°^Ämµ¹¤j®a¨Ï¥Î~~
¤]·PÁº޲z¸sªº©ÞÀ»P«H¿à!!! ¤W¥«Âd¤T¤jªk¤H¶R½æ¶W.zip (841.44 KB)

¦^´_ 1# VBALearner
¦pªG¥u­pºâ¤G¤T¤Q¤Ñ¡A³o¼Ë©ñ¨S¦³°ÝÃD

¦pªG­n­pºâ¤@¤G¦~¡A¥i¯à­n©ñª½¥ß¦¡ªº¡A³z¹Lsql»yªk¡A©ñ¶i²³æªº¸ê®Æ®w¦paccess  sqliteµ¥¡A ®e¶q¤j³t«×§Ö

excel¥u¬O¤U©R¥O»P³Ì«á¸ê®Æ§e²{ªº¦a¤è¡AÅý¸ê®Æ®w¦Û¦æ¹Bºâ

³t«×¶W§Ö

°Ñ¦Ò¬Ý¬Ý

¨Ò¦p¥H¤U¹Ï¤ù¡A¦pªG·|¤U«ü¥O¡A¥i¥H¬d¥X¬Y®É¶¡¤º¡A¥~¸ê¦@¶R´X¦¸¡A¦ûªÑ¥»¦h¤Öµ¥¡A®æ¦¡«Ø¥ß¦n¡A·|¬d¦h¤Ö´N¬Ý§Asql¥\¤O
2016-08-04_084701.gif
2016-8-4 08:47

TOP

¥»©«³Ì«á¥Ñ VBALearner ©ó 2016-8-4 10:25 ½s¿è

¦^´_ 2# joey0415

«z......±z°ª¤â±M·~...¦ý¬O§Ú¤£·|¼g...sql³o­Ó»y¨¥?! ¤£¹LAccess­Ë¬O¦³¡A¥L¤]¬O¥ÎVBA´N¯à¾Þ§@ªº¨S¿ù§a? ³o¼Ë¦n¹³¬OAccess¤ñ¸û®e©ö¤W¤âªº·Pı...
¥i¥H½Ð±Ð±z¦b­þ¸Ì¾Ç²ß¸ê®Æ®wªºµ{¦¡»y¨¥¶Ü?! ±zªºªk¤H¸ê®Æ®wªþ¹ÏÀ³¸Ó´N¬O±zªº¤j§@§aXD?
§Ú¦A¥h¥«­±¤W½´X¥»Accessªº®Ñ¬Ý¬Ý¡AÁÂÁ±zªº·N¨£

TOP

¥»©«³Ì«á¥Ñ joey0415 ©ó 2016-8-4 14:18 ½s¿è

¦^´_ 3# VBALearner

´X¸Uµ§©Î´X¦Ê¸Uµ§¸ê®Æªº¾ã¦X¡A©ñ¸ê®Æ®w¤~¬O¥¿½T

³z¹Lexcel vba  ¾Þ§@¸ê®Æ®w  ¨Ã¨Ï¥Îsql»yªk¨Ó¿ï¨ú§A­nªº¸ê®Æ¤~¬O¥¿½T

¯uªº§Ö¤S¦³®Ä

sql»yªk±Ð¾Ç

http://www.1keydata.com/tw/sql/sql.html

excel vba  connect  access ±Ð¾Ç
http://tgw1029.blogspot.tw/2010/01/excel-vba-adoaccess_06.html

http://blog.xuite.net/crdotlin/excel/9056917-Access%E8%B3%87%E6%96%99%E5%BA%AB%E7%9A%84%E9%80%A3%E7%B5%90

http://tgw1029.blogspot.tw/2010/01/excel-vba-adoaccess.html

¼v­µ±Ð¾Ç

https://www.youtube.com/results?search_query=excel+vba+connect+access

TOP

¦^´_ 3# VBALearner


    ±zªºµ{¦¡½X¥u¦³¾ã²z¸ê®Æªº³¡¤À
¥D­n¤U¸ü¸ê®Æªºµ{¦¡½X,§AªºMyfile ¨S¦³´£¨Ñ¡A®£©Èºô¤Í­ÌµLªk¾Ç²ß¦p¦ó¤U¸ü®@!
Workbooks.Open "C:\¤T¤jªk¤H§ó·s°Ï\" & myfile
PKKO

TOP

¥»©«³Ì«á¥Ñ VBALearner ©ó 2016-8-4 15:26 ½s¿è

¦^´_ 5# PKKO

§Úªºµ{¦¡½X¸Ì¦³¤@¬q
myfile = Dir("C:\¤T¤jªk¤H§ó·s°Ï\201*")
¥i¥H±qC¼Ñªº¤T¤jªk¤H§ó·s°Ï¸ê®Æ§¨¨ú¥XXXX¶}ÀYªºExcelÀÉÀɦW§@¬°¸ê®Æ¨Ó·½"myfile"
¤£¹LµLªk¦Û°Ê¤U¸ü´N¬O¤F¡A­n¤â°Ê¤U¸ü«á§âÀɮײ¾¨ìC¼Ñ§ó·s¸ê®Æ§¨¸Ì¡AÁÙ¬O±zÄ@·N¤À¨É¦p¦ó±qºô­¶¤W¦Û°Ê¤U¸üÀÉ®×OwO?!

TOP

¦^´_ 4# joey0415

³á¤Ñ°Ú~~·PÁ±z´£¨Ñ³o»ò¦h¸ê®Æ®wªº±Ð¾Çºô¯¸!!!
§Ú¤é«á¦A¦V±z§V¤O¾Ç²ß!!!
¥u¯à¥[­Ó¦n¤Í¥ýxD

TOP

¦^´_ 6# VBALearner


    ¤F¸Ñ,¬O§Ú»~·|¼ÐÃD,¥H¬°¬O¦Û°Ê¤U¸ü,¦ý±zªº¼ÐÃD¤w¸g«Ü©úÅã¬O·J¾ã³B²z
©êºp©êºp~
PKKO

TOP

¦^´_ 1# VBALearner
§A¨º "C:\¤T¤jªk¤H§ó·s°Ï\201*" ¸Ìªº
Àɮפº®e¬O§_¦p¡G
BIGD_1050804.rar (11.14 KB)
¤@¼Ë¡H
¬O§_¤]½Ð¤W¶Ç¤@­Ó "C:\¤T¤jªk¤H§ó·s°Ï\201*"
¤¤¤§¥ô¤@ÀÉ®×°µ¬°°Ñ¦Ò¡H

TOP

¦^´_ 9# c_c_lai

®¦®¦BIGD*¶}ÀYªº¬O¤WÂd¶R½æ¶W¤é³ø
201*¶}ÀYªº¬O¤W¥«¶R½æ¶W¤é³ø
SQUOTE*¶}ÀYªº¬O¤WÂd¦æ±¡ªí
A112201*¶}ÀYªº¬O¤W¥«¦æ±¡ªí

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD