c_c_lai

¦^´_ 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¡G­n±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)

¤U¸ü¦¸¼Æ: 100

2012-6-15 07:34

c_c_lai

¦^´_ 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¥ý·Ó§Ú¤W­zªº¤èªk¸Õ¸Õ¬Ý¡A¦pªG¤£¦æªº¸Ü¡A¦A§i¶D§Ú¡C

c_c_lai

¦^´_ 12# HSIEN6001

1.     ' Const DBÀÉ®× = "´Á³f²Î­p.accdb"
   
2.     Const DBÀÉ®× = "´Á³f²Î­p.mdb"  
   
3. 
   
4.     ' ¦pªG­n¨Ï¥Îªº¸ê®Æ¬O 2000 ~ 2003ªº¡ymdf¡z®æ¦¡ÀɮסA«hProvider
   
5.     ' «K­n«ü©w¬°¡yMicrosfot.JET.OLEDB.4.0¡z
   
6.     ' myCN.Provider = "Microsoft.ACE.OLEDB.12.0"  ' 2007 ~ 2010¤§«Å§i
   
7.     myCN.Provider = "Microsfot.JET.OLEDB.4.0"     ' 2000- ~ 2003¤§«Å§i
   
8. 
   
9.     myCN.Open ActiveWorkbook.Path & "\" & DBÀÉ®×  ¡¥ ¶}±Ò Access ÀÉ®×

½Æ»s¥N½X

¤U¸ü (178.46 KB)

2012-6-15 21:40

´Á³f¸ê®Æ.rar (646.7 KB)

¤U¸ü¦¸¼Æ: 39

2012-6-15 21:43

c_c_lai

¦^´_ 12# HSIEN6001
¥t¥~¦A§K¶OÃØ°e¡G
SQL»yªk±Ð¾Ç.pdf (957.95 KB)

¤U¸ü¦¸¼Æ: 69

2012-6-15 21:48

½Ð°Ñ¾\ Page 70 ¥H«á¤§  ¦b Excel ¤¤¶}±Ò Access ¸ê®Æ ªº¬ÛÃö¹ê¨Ò¡A
«OÃÒ¹ï©pµ¥·|¦³¹ê½èªºÀ°§U¡C

c_c_lai

¦^´_ 16# HSIEN6001
©p¤w«Ø¥ß¦n¸ê®Æ®w¤F¶Ü¡H

¤U¸ü (166.83 KB)

2012-6-16 08:34

¦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

c_c_lai

¦^´_ 20# HSIEN6001
Àô¹Ò³]©w¦p¤ºªþ¤§¹Ï«¬¡A²Î­p¤é´Á§Ú¤w¥[¤J¡A
µ{¦¡¥ç­×¥¿¡A¦pªþ¥ó¡C ©p¸Õ¸Õ¬Ý¡I
VBA½s¿èÀô¹Ò.rar (659.92 KB)

¤U¸ü¦¸¼Æ: 44

2012-6-16 11:19

c_c_lai

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

¤U¸ü¦¸¼Æ: 35

2012-6-16 13:23

¤U¸ü (150.84 KB)

2012-6-16 13:24