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

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

¦^´_ 6# VBALearner


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

TOP

¦^´_ 4# joey0415

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

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

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

¥»©«³Ì«á¥Ñ 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

¥»©«³Ì«á¥Ñ 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

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

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD