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

[µo°Ý] vba»P¸ê®Æ®wªº³sµ²

[µo°Ý] vba»P¸ê®Æ®wªº³sµ²

¦pªG§Ú¥Ø«e¦³¤j¶qexcel¸ê®Æ(.xls, .csv)
¦³¤@¨ÇVBAªº°ò¦ ¦ý¬O¹ï¸ê®Æ®w§¹¥þ¨S·§©À
¦b¥i¨£ªº¥¼¨Ó¸ÌÁ`Àɮפj¤p·|¶W¹L2GB(¨â­Ó¤ë)
±NÀɮ׶פJ¸ê®Æ®wªº®É­Ô®e¶q¬O§_·|¤ñ­ìexcelÀɤp?
·Q­n¾ã²z¨Ã´£¨Ñ¤é«á¬d¸ß(¶È¨Ñ­Ó¤H©Î¤Ö¼Æ¤H¨Ï¥Î)ªº¸Ü
À³¸Ó¨Ï¥Î­þºØ¸ê®Æ®w©O? ÁÙ¬O¨ä¹ê¤£¨Ï¥Îºô¸ô³s½u´N¨S¦³¥Î¸ê®Æ®wªº¥²­n?
¤S¹ïVBA¨Ó»¡ ­þºØ¸ê®Æ®wªº³sµ²¤ñ¸û¦³®Ä²v?
¦pAccess, MySQL,...²³¦h¸ê®Æ®wÅý¤H²´ªá¼º¶Ã
¤£½T©w¸Óµo¨ì­þª©
ÁٽЫe½ú­Ì½ç±Ð><

¦^´_ 1# lalalada

¶×¤J¸ê®Æ®w;·íµM·|ÁY¤p«Ü¦h
µy·L¦b¥h¿¾¦sµ×¤§«á,¥i¥H©ñ§ó¦h

    ³o¤è­±¤§«eª¦¤åªº²Lª¾ÃÑ --->Sorry! ²Lªº³á! ¥ýÁn©ú!
Access---->¤£·|»yªk¤]¥iÀ³¥Î¤W¤â;¦ý·|ÂI¹q¸£»y¨¥§ó¦³®Ä²v
2003¤´¨ü­­¨î©ó2G ,»Ý¤Á³Î¥X¥h¦n´X­Ó  ¥Ø«eÀ³¥Î---->(¸ê®ÆÀɤε{¦¡ÀɤÀ¶}©ñ³Ì¦n)

MySQL  ~O.p
¦U¤j°ª¤â,¦n¹³³£±ÀÂ˳o³¡¥÷.  
§ÚÁÙ¦b²LÅy´åªa,§ó§O´£§l¦¬¤F

TOP

«Øij¤£­n¥ÎAccess+VBA,¦]¬°«Ü¯Ó®É,®ÄªG¤]¤£¦n,¥i¥H«Øij¥ÎMySQL³o¼Ëperformace·|¦n«Ü¦h,¥i¥H°Ñ¦Òhttp://blog.yam.com/white5168

TOP

¦U¦³¦Uªº¦n³B, µø²Å§Aªº¹ê»Ú»Ý­n
Access- ¤è«K²¾°Ê(§âmdbÀɥѤ½¥q§Û¦^¨ì®a,¸òxlsÀɤ@¼Ë), ¦pªG¬O¥ÎEXCEL®³¸ê®Æ,¤£»Ý¦w¸Ëaccess
¤ñ°_EXCEL¸û¾A¦X©ñ¤j½g¤å¦r¼Æ¾Ú(MEMO), ¤ñ¸û¨ä¥LDBMS©ö¾Ç.
MySQL, MS SQL Server Express - §K¶O,§Ö³t, ¦ý»Ý­n¦w¸ËServer,¤£¯àÀH«K²¾°Ê, (²¾°Ê»Ý­nbackup/restore)

>±NÀɮ׶פJ¸ê®Æ®wªº®É­Ô®e¶q¬O§_·|¤ñ­ìexcelÀɤp?
ExcelÀɦpªG¥u¦³¸ê®Æ¤å¦r,«Ü¤Ö·|¹L2G.
¬Ý¬Ý¬O¤£¬O¦³¦h¥X¨Óªº±±¥ó/¹Ï¤ù,´î¤@¤UÂé

©ñ¤J¸ê®Æ®wªº­ì¦], ¥D­n³q±`¬O³o´X­Ó:
1.¼Æ¾Ú¶q¦h: ¦³¦h¤Ö¦æ¼Æ¾Ú(¦p > 6¸U¦æ)
2.¼Æ¾Ú¦h©ó¤@­Ó"ªí", ¥Î¨Ó°µÃöÁp / DISTINCT COUNT µ¥
3.¦h¤H¦P®É¬Ý/¦P®É¥[´î¼Æ¾Ú (³o­Ó¥ÎEXCEL·|¤ñ¸û§xÃø)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 2# HSIEN6001
¦^´_ 3# white5168
¦^´_ 4# kimbal

·PÁ¦U¦ìªº¦^ÂÐ!
¦b¬d¹L¤@¨Ç¸ê®Æ¤§«á
À³¸Ó·|¨Ï¥ÎMySQL
³Ìªñ§Ú¤]¤@ª½­W­W«ä¯Á¬°¤°»ò§ÚªºexcelÀÉ·|³o»ò¤j
¥H³o¼Ëªº¤j¤p ¤@¦~¥÷ªº¸ê®Æ®e¶q´N¬Û·íÅå¤H¤F
¦Ó¥B³B²z°_¨Ó¤]¤£¤è«K~"~

TOP

¦^´_ 5# lalalada


    ­èª¦¤å,©Î³\§A·|¥Î¤W´Nµ¹§A¶K¹L¨Ó
¦³Ãö³o³¡¥÷ªº (¤£¦P¼h­±«ä¦Ò)
http://www.aspxhome.com/database/access/20085/383623.htm

TOP

ok!
·PÁ§A
¬Ý°_¨Óaccess¤]¤w¸g¬Û·í¨¬°÷¤F
¨º»ò¥H¤è«K©Ê¨Ó»¡´N¸Ó¿ïaccess...
¦Ó¥B§Ú¬Q¤Ñ»®µMµo²{¨Ï¥Î2010¤U¸ü¤U¨ÓªºÀɮפñ2003¤U¸üªº­n¤p«Ü¦h

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD