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

[µo°Ý] Excel¤u§@ªí³æ»PAccess¸ê®Æ®wªºVBA¤¬°Ê°ÝÃD

¦^´_ 10# c_c_lai

§Úµo²{stillfish00¤j¯u±o«Ü²Ó¤ß¡A¤W¦¸timerªº¨Æ¤]¬O¥LÀ°¦£ªº

§Ú·Q°Ý ¨Ï¥ÎACCESS ¸ê®ÆÀɮɡA¥i¥H¦h¤H¦P®É¦s¨ú¶Ü?(¬ðµM·Q°_¥H«e¥ÎDBASEªº¤@¨Ç¸ê®ÆÂê©w¦s¨ú°ÝÃD¡A°Ý±o¦³ÂIÅ¢²Î½Ð¤Å¤¶·N)

§Ú¶]¤@¨Çµ²ºc¤ÀªR¡A¥H«e¬O¬ÝTXTÀÉ¡A²{¦b¤]¦h¤FACCESSªºMDB¥i¥H¨Ï¥Î¡A¬Ý¨ì§A³o½gÅý§Ú¦b·Q¨Ï¥ÎMDB³B²z·|¤ñTXTÀɦs¨ú§Ö¶Ü?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  c_c_lai

§Úµo²{stillfish00¤j¯u±o«Ü²Ó¤ß¡A¤W¦¸timerªº¨Æ¤]¬O¥LÀ°¦£ªº

§Ú·Q°Ý ¨Ï¥ÎACCESS ¸ê®Æ ...
ML089 µoªí©ó 2013-12-11 09:33

¥H©¹¦­´Á dBase/dBaseII ¦b¸ê®Æ¦s¨ú®É¡A»Ý¦Ò¼{¦h¨Ï¥ÎªÌ (Multi User) ¤§¸ê®Æ¦s¨úªºÂê©w»PÄÀ©ñ¡A
¥HÁקKÀɮ׳QÂꦺ (Dead Lock)¡A«á´ÁºtÅܪº Access/Clipper µ¥¸ê®Æ®w¦b I/O ¤W¤w¦³§ï¶i¤Î³B²z¡C
¥B³£¿í¦æ ANSI SQL ªº¼Ð·Ç³W½d¡C©Ò¥H¥Ø«e¤@¯ëµ{¦¡¤H­û (Programmer) §¡¦³¤@¦@ÃÑ¡A§Y¦b³B²z
¦³Ãö¸ê®Æ®w§@·~¡A¤@°õ¦æ§¹²¦¡A«KÀH¤âÃö³¬¸ê®Æ®w¡C¦p¦¹¡A¶ë¨®ªº²~ÀV°ÝÃD«K¦æ¦Ó­°§C¡C   
²{¤µ­n¦Ò¶qªº¡A¬O¸ê®Æªº¹ê»Ú¯à³B²zÀx¦s¶qªº¦h¹è¡A¯Á¤Þªº°õ¦æ³t«×¡A³Ì¤jªºÀx¦s¸ê®Æµ§¼Æµ¥¡C
¬°¦ó¦³¨Ç¥ø·~·|¥h¦Ò¶q±Ä¥Î MS SQL¡B§ó³ÓªÌ·|¥hµû¦ô PosgreSQL¡BMySQL¡BInformix¡BInterBase¡B
Oracle µ¥ª¾¦W±M·~¸ê®Æ®w¬ãµo¼t°Ó¡A¥ç¬O¦¹¹D²z¡C
¤]¯uÁÂÁ stillfish00¤j¤j¡A¥L¯u±o«Ü²Ó¤ß¡A³o¤]³\¬O·í§½ªÌ°g§a¡I

TOP

¦^´_ 12# c_c_lai


ÁÂÁ§A¡A»¡©úªº«Ü²M·¡¡C(PS §Ú°O±o¤W¦¸§Ú¤w¸g¦^ÂйL¡A§Ú¦n¹³¦³¦Ñ¤Hè§b¯g¤F «¢«¢)

EXCEL¸ê®Æ¦h¤H¦P®É¨Ï¥Îªº¤¶²Ð«Ü¤Ö¡A©ÎÀ³¸Ó¥ÎACCESS§a
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# ML089
¤§«e´¿¸g±N Excel ÀɮפW¶Ç©ñ¸m©ó Google Chrome ­Ó¤HÀɮ׬ö¿ý¤º¡A
´£¨Ñ¦h¦ì§@·~¤H­ûÀH®É°O¿ý¤Î­×¥¿¡A°O¾Ð¤¤¦n¹³¤]¤£´¿¦³µo¥Í²§ª¬°¦±¡¨Æ¡C

¥H©¹¦b¾«e¹ê§@ªº¸ê®Æ³B²z¡A´X¥G³£°O¿ý©ó Clipper, MS SQL¡B
¥H¤Î PostgreSQL ¤W¡C¦]·¥¤Ö±µÄ² Office©Ò¥H¥u¦³¦b½m²ß®É¤~
·|¥h¸Õ¹Ï¾Þ§@ Access¡A¦ý¤£¬O«Ü¼ô¡C
¨ä¹ê¸ê®Æ®wªº§@·~³B²z¼Ò¦¡³£¬O«Ü¹p¦Pªº¡A«Ü®e©öÁ|¤@¤Ï¤T¡C¡C

2014¦~¾÷²¼°O¿ý.rar (79.06 KB)

TOP

¦^´_ 14# c_c_lai
2014¦~¾÷²¼°O¿ý¡G
¥»µ{¦¡¤§Ã±ÃÒ¶O¥Î¡B¾÷²¼¶O¥Îªº¥[Á`­pºâ³B²z§Ú¤w¸g±N¥¦
¥[¤J¤F (§Q¥Î¦r¨åª«¥óªº³B²z)¡A¨Ï¥ÎªÌ©óÁA¸Ñ Excel ªí³æ³B²z¡B
¥H¤Î Access ªº¸ê®Æ¦s¨ú«á¡A«K¥i±qµ{¦¡¤¤±N¥¦­Ì¤©¥H¤À¶}¡A
¦Ó¥uÂ^¨ú¨Ï¥ÎªÌ¨ä¥»¨­»Ý¨Dªº³¡¤À¡C ¥Ø«eµ{¦¡¥]§t A¡BB ¨â³¡¤À¡G
A¡B¯Âºé Excel ¤u§@ªí³æ (¥»¨­) Àx¦s§@·~¡A¸ê®ÆÀx¦s©ó¤u§@ªí³æ¤¤¡F
B¡B±N©Ò¦³³B²z¸ê®Æµ²ªGÀx¦s¦Ü Access ¸ê®Æ®w¤¤¡A¤è«K¤é«á¦s¨ú§@·~¡C

TOP

¦^´_ 14# c_c_lai

ÁÂÁ§Aªº¸Ô²Ó»¡©ú

EXCEL Àɮרâ­Ó¤H¦P®É¶}±Ò´N·|¦³°ÝÃD¡A°£«D³]¬°¦@¥Î¼Ò¦¡¡A¦@¥Î¼Ò¦¡§Ú¸Õ¹L·|¶V¾Þ§@ÀÉ®×·|¶V¨Ó¶V¤j¾Þ§@¤]·|¶V¨Ó¶VºC¡A¥i¯à¬OEXCELª©¥»¤£¦P®Éªº°ÝÃD(ÁÙ¦b´ú¸Õ)

Á¿¨ì Clipper ¬O§Úªº³Ì·R¤]¬O³Ì«ë¡A¯u¬O©¹¨Æ¥u¯à¦^¨ý

¨ä¹ê¸ê®Æ®w³B²zÀ³¸Ó­n¨Ï¥ÎACCESS¨Ó³B²z¤ñEXCEL¦n¡A¥u¬O¤½¥q¤j³¡¤À¬O°µ¤uµ{­pºâ¤uµ{®v¥u·|¥ÎEXCEL¡AÁö¥Ø«e¤uµ{­pºâµ{¦¡¤]¤ä´©MDB¡A§ÚÁÙ¬O·Q¥ÑMDB±N¸ê®Æ·h¦ÜEXCEL¤j®a¤ñ¸û¦n¨Ï¥Î¡C
§Aªºµ{¦¡¥i¥HÅý§Ú¦n¦n¬ã¨s¤@¤U¡A¥i¯à»Ý­nªáÂI®É¶¡®ø¤Æ¡C

¨ä¹ê³o¨Ç¤£§Úªº¤u§@¤º®e¡A§Ú¥u¬O¦³¿³½ì¬ã¨sEXCEL¡A©Ò¥H¸}¨BºC¤@ÂI¡Aµ¥¹L¤@¨Ç®É¤é¦³°ÝÃD¦A¨Ó½Ð±Ð¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# c_c_lai


    Æg
§A²q!!

TOP

§Ú±N acdx ¤j¤j©ó 2013-12-11 16:52 ´£°Ýªº
"¦p¦óÅýComboBox¥i¥H¥Î·Æ¹«ºu°Ê?" ¸Ñ¨M¤è®×
¥[¥HÀ³¥Î¥[¤J¨ì "ñÃÒ¤º®e1"¡B"ñÃÒ¤º®e2"
¤º¡A¥i§@¬°½d¨Ò¤Þ¥Î¡A¦p©|¦³§ó¨Îªº³B²z¤èªk
©|½Ð¦U¦ì¤j¤j«ü±Ð¡I
2014¦~¾÷²¼°O¿ý.rar (84.95 KB)

TOP

¥»©«³Ì«á¥Ñ JEAN ©ó 2013-12-26 09:51 ½s¿è

¦^´_ 1# c_c_lai


   ±z¦n:
³o­Ó2014¦~¾÷²¼°O¿ýÀɮ׬O§Ú°µªº,¸Ì­±¦h¤@­Ó"¾÷²¼§@·~"...³o­ÓªF¦è¦n¹³¦³¤@ÂI©Ç©Çªº
½Ð°Ý§A²{¦b¬O¼g¾÷²¼§@·~ªºVBAªºµ{¦¡,ÁÙ¬O¸Ì­±ªº"¾÷²¼"ªºVBAµ{¦¡¡C

§Ú¬Ý¤£À´¸Ì­±¦b¼g¤°»ò...¾÷²¼§@·~¸Ì­±ªºªí®æ³£¤£¯à¥Î

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2013-12-26 10:53 ½s¿è

¦^´_ 19# JEAN
§Ú´N¬O¤@®É§Ñ¤F·íªì¬O½Ö´£°Ýªº¡A¹ê¦b
¤Ó¦n¤F¡I
·íªì©pªº´£°Ý¬O "¾÷²¼"¡A§Ú¬Ý¤F¤§«á«K
¸ÕµÛ±N¥¦§ï¦¨ ¤u§@ªí³æ¡B¥H¤Î Access ¸ê®Æ®w
³£¯à°õ¦æªº¤è¦¡ (¦P¨B¥Ü½d¦p¦ó§@·~)¡CÁ|¨Ò¨Ó»¡¡G
¦pªG³æ¯Â¦a¥u·Q¦b Excel °µ¿é¤Jµe­±¡AÀx¦s®É±N
¸ê®ÆÀx¦s¨ì  Access ¸ê®Æ®w¡A¨º»ò«K±N Excel "data" Àx¦s
¸ê®Æªº³¡¤À²¾°£¡A¥u«O¯dÀx¦s Access ¸ê®Æ®wªºµ{¦¡½X¡C
¤Ï¤§¡B¥çµM¡C©p¤@©w·|°Ý¬°¦ó¬Oºî¦Xªº¡A³o¯Âºé¬O¬°¤F
´ú¸Õ¡B¤ÎÁA¸Ñ¡A¦p¦ó¨Ï¥Î Excel À³¥Î ADO ³B²z¸ê®Æ°ÝÃD¡A
¥H¤Î¦p¦ó¦P®É³B²z Access ¸ê®Æ®wªºÅª¨ú¡B¬d¸ß¡B§R°£¡B¥H¤Î
¼g¤Jªº»yªkÀ³¥Î¦Ó°µ¥X¨Óªº½d¨Ò¡C©Ò¥H¤~±N©p·íªìªº´£°Ý
§¡¼g¦b "¾÷²¼§@·~" ¡B¥H¤Î "data" ¤º¤§¬G¡C¦p¦¹¡B¥ç¦^´_¤F
¤u§@ªí³æ "¾÷²¼" ªº³B¸Ì´£°Ý¡C³o»ò»¡©ú¬O§_¸Ñµª¤F©pªº°ÝÃD¡H

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD