½Ð°ÝAccess ¥i¥H°µªÑ²¼ºÞ²z¶Ü?
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 8# jayer
¦^´_ 1# pig172
¦^´_ 7# HSIEN6001
µª®×¬O¡G µ²¦X Access ¸ê®Æ®w (¦p«D³B²z«D±`Ãe¤jªº¸ê®Æ®w¡A§_«h¦b¸gÀÙ¦¨¥»ªº¦Ò¶q¤U¡B¤O¨D¤è«K¡B
¥H¤Î»PExcel¹ê°ÈÀ³¥Î±¨Ó»¡¬O¥i¤©°Ñ¦Òªº)¡A¤]¬OÆZȱo±ÀÂ˨ϥΪº¡C
ªþ¤W¤@Ó½d¨Ò¦@¤j®a°Ñ¦Ò¡AAccess »P Excel ¹ê»Ú¤W¤§À³¥Î(VBA)¡C (¦U¦ì¥i¦Û¦æµo´§¡A¥Ø«e§ÚÓ¤Hªº°õ¦æÀô¹Ò¥ç¬O¦p¦¹À³¥Îªº)
¥]§t¡G(¤@) ¿ï©w«ü©w¤é´Á¡A±q Access ¤¤±N«ü©w½d³ò¤º©Ò¦³ªº¸ê®Æ¥þ³¡¨ú¥X¶×¦Ü «ü©w¤§ Excel ¤u§@ªí³æ¤º¡C
(¤G) Àˬd«ü©w¤é´Á¬O§_¦s¦b©ó Access ¤¤¡C (ª`·N¡G¬d¸ß®É¤é´ÁÄæ¦ì«e«án¥H "#" & ¿ï©w«ü©w & "#" ªí¥Ü¤§ )
(¤T) ´M§ä«ü©w˦^¤Ñ¼Æªº·í¤é¬Oþ¤@¤Ñ¡H (Ä´¦p¡Gn±oª¾Ë¼Æ²Ä´X¤Ñ¬O´X¤ë´X¸¹µ¥)
(³oÓ°ÝÃD¬O§Ú¼Æ¤é«e¦b¥»½×¾Â¤§´£°Ý¡A¦ý°£¤F HSIEN6001 ¤j¤j¦^ÂÐ¥~¡Aµ²ªG¸Ó¥÷´£°Ý¤]¤£ª¾¦ó¦]¡A
«K±q¦¹±q¥»½×¾Â¤H¶¡»]µo®ø¥¢ªºµL¼vµLÂÜ¡A³Ì«á¤£±o¤£¦Û¦æ³}®Ñ©±¬d¸ê®Æ¡A¦A¦ÛÓ¨à´ú¸Õ¤~¦³¤Fµ²ªG¡C)
¦bExcel¤¤¶}±ÒAccess¸ê®Æ´ú¸Õ.rar (257.85 KB)
|
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 10# HSIEN6001
§Ú¤âÀY¤W¨S 2003¡A¦pªG©p±NÀÉ®× Extension Name accdb ª½±µ§ï¦W¬° mdb¡A¤£ª¾¥i§_¶}±Ò¡A
§Ú³oºÝ¦p¦¹°µ (´Á³f²Îp.accdb Rename to ´Á³f²Îp.mdb) ¥Î 2010 ¬O¥i¥H¶}±Òªº¡A©p¸Õ¸Õ¬Ý¡I
§Úµoı 2010 Access ¥t¦s·sÀÉ¡A ¥¦¨S¦³¹³ Excel ¥i¥H¦s¦¨ 2003 ªº xls ®æ¦¡ªº¿ï¶µ¡A
§A¥ý·Ó§Ú¤Wzªº¤èªk¸Õ¸Õ¬Ý¡A¦pªG¤£¦æªº¸Ü¡A¦A§i¶D§Ú¡C |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 12# HSIEN6001 - ' Const DBÀÉ®× = "´Á³f²Îp.accdb"
- Const DBÀÉ®× = "´Á³f²Îp.mdb"
- ' ¦pªGn¨Ï¥Îªº¸ê®Æ¬O 2000 ~ 2003ªº¡ymdf¡z®æ¦¡ÀɮסA«hProvider
- ' «Kn«ü©w¬°¡yMicrosfot.JET.OLEDB.4.0¡z
- ' myCN.Provider = "Microsoft.ACE.OLEDB.12.0" ' 2007 ~ 2010¤§«Å§i
- myCN.Provider = "Microsfot.JET.OLEDB.4.0" ' 2000- ~ 2003¤§«Å§i
- myCN.Open ActiveWorkbook.Path & "\" & DBÀÉ®× ¡¥ ¶}±Ò Access ÀÉ®×
½Æ»s¥N½X
´Á³f¸ê®Æ.rar (646.7 KB)
|
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 12# HSIEN6001
¥t¥~¦A§K¶OÃØ°e¡G
SQL»yªk±Ð¾Ç.pdf (957.95 KB)
½Ð°Ñ¾\ Page 70 ¥H«á¤§ ¦b Excel ¤¤¶}±Ò Access ¸ê®Æ ªº¬ÛÃö¹ê¨Ò¡A
«OÃÒ¹ï©pµ¥·|¦³¹ê½èªºÀ°§U¡C |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-6-16 08:42 ½s¿è
¦^´_ 16# HSIEN6001
©p¤w«Ø¥ß¦n¸ê®Æ®w¤F¶Ü¡H
¦p¤£¦æªº¸Ü¡A§A¥i¥H§â¸ê®Æ®w¶Ç¹L¨Ó±q§Ú³oºÝ¨Ó¸Õ¸Õ¬Ý¡A
2010 Access ¬O¥i¥H¥´¶} 2003 ªºÀɮתº¡A
³o¤]¬O Microsfot ªº·d¦º¤Hªº½æÂI¡I
²Îp¤é´Á½T¹ê¬O¶}½L¤é¤§¬ö¿ý¡C
P.S. Microsfot.JET.OLEDB.4.0 ¦n¹³n¦b¨Ï¥Î«e³]©w¤@¨Ç OleDB ªº¤Ä¿ïËç¡C |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 20# HSIEN6001
Àô¹Ò³]©w¦p¤ºªþ¤§¹Ï«¬¡A²Îp¤é´Á§Ú¤w¥[¤J¡A
µ{¦¡¥ç×¥¿¡A¦pªþ¥ó¡C ©p¸Õ¸Õ¬Ý¡I
VBA½s¿èÀô¹Ò.rar (659.92 KB)
|
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 21# HSIEN6001
¬°¤F´ú¸Õ©p»¡ªº°ÝÃD¡A§Ú¥t¥~¥[¸Ë¤F 2003 Office SP3 ¨Ó´ú´ú¬Ý¡A
§Ú±N Provider µyµyקï¤F¤@¤U myCN.Provider = "Microsoft.JET.OLEDB.4.0"
×¥¿¬° myCN.Provider = "Microsoft.Jet.OLEDB.4.0;"¡A ¦P®É±N¦U¿ï¶sªº«ü©w¥¨¶°
¦A½Æ¬d¤@¦¸¡Aµ{¦¡ªº§PÂ_¥ç¤@¨Ö×¹¢¡A²{¦b©pÀ³¸Ó¥i¥H¦w¤ß¦a¨Ó´ú¸Õ 2003ª©¤F¡C
VBA½s¿èÀô¹ÒOK.rar (813.15 KB)
|
|
|
|
|
|
|