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

HSIEN6001

¦^´_ 11# c_c_lai

C¤j,ÁÂÁ¦^ÂÐ~

    ³ø§i!~~±z»¡ªº¤è¦¡"§ïmdb"
¦­¤W¤w¸g®¨®¨¸Õ¹L¤F--->¤£¦æ­C!

­è­è²¤¬Ý¤@¤UVBA,«ü©w¶×¥Xªº¸ê®Æªí¨â­Ó
FROM ´Á³f²Î­p & FROM ²Î­p¤é´Á

~©çÁÂ!!¦pªG¤è«Kªº¸Ü~

³Â·Ð±z,¶×¥X³o¨â­Ó¸ê®Æªí¬°.xls ©Îtxt
Åý§Ú¦Û¦æ³]¥ß2003ªºAccess
´Á³f²Î­p.mdb

¤è«K¾Ç²ß¸ÓVBA©óAccessÀ³¥Î
~¤£³Ó·P¿E

¸É­z¡G
¶È¶È®æ¦¡¤Î¼Æµ§¸ê®Æ¤]¥i
¤è«K´ú¸Õ¤Î¾Ç²ß´N¦n
ÁÂÁÂ!

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

HSIEN6001

¦^´_ 14# c_c_lai


    C¤j,ÁÂÁ¤À¨É¤Î²Ó¤ß¥mÀ{
¶}¤ß¦¬¤U¥ý^^

¬Ý¨ì¨º»ò¦h¥ý¶i,³o»ò´Î
¦Û¤v¤£¦h¥[±j¨Ç,¤]«Ü¤£¦n·N«ä....^^!!
ÁÂÁ±z¤£§[«ü¾É

«á¾Ç~§V¤O¾Ç²ß¤¤
~ÁÂÁ±z~

HSIEN6001

¦^´_ 13# c_c_lai

C¤j,½Ð°ÝVBA¸Ì«ü¦V¥t¤@­Ó¸ê®Æªí
FROM ²Î­p¤é´Á
¬O¦³¶}¥«ªº"¥æ©ö¤é´Á"?


¸Õ¤F~°õ¦æ¥X²{°»¿ù¦b
    myCN.Open ActiveWorkbook.Path & "\" & DBÀÉ®×

mannyhsu

§Ú¤]«Ü·Q±N¸ê®Æ¦s¦b access db ¤¤, ¥H excel ¥h¾Þ§@ ...

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

HSIEN6001

¦^´_ 18# c_c_lai


    ¨º´N¤£¦n·N«ä,³Â·Ð±zÀ°§Ú¬Ý¬Ý
°ÝÃDÂI,¤w¸g¥Î§Ö·Ó¦sÀÉ©óÀ£ÁYªþ¥ó¤¤

´ú¸Õ.rar (596.82 KB)

¤U¸ü¦¸¼Æ: 17

2012-6-16 09:27

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