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

½Ð°ÝAccess ¥i¥H°µªÑ²¼ºÞ²z¶Ü?

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

TOP

¥»©«³Ì«á¥Ñ HSIEN6001 ©ó 2012-6-15 14:53 ½s¿è

¦^´_ 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
ÁÂÁÂ!

TOP

¦^´_ 12# HSIEN6001
  1.     ' Const DBÀÉ®× = "´Á³f²Î­p.accdb"
  2.     Const DBÀÉ®× = "´Á³f²Î­p.mdb"  

  3.     ' ¦pªG­n¨Ï¥Îªº¸ê®Æ¬O 2000 ~ 2003ªº¡ymdf¡z®æ¦¡ÀɮסA«hProvider
  4.     ' «K­n«ü©w¬°¡yMicrosfot.JET.OLEDB.4.0¡z
  5.     ' myCN.Provider = "Microsoft.ACE.OLEDB.12.0"  ' 2007 ~ 2010¤§«Å§i
  6.     myCN.Provider = "Microsfot.JET.OLEDB.4.0"     ' 2000- ~ 2003¤§«Å§i

  7.     myCN.Open ActiveWorkbook.Path & "\" & DBÀÉ®×  ¡¥ ¶}±Ò Access ÀÉ®×
½Æ»s¥N½X
04.png
2012-6-15 21:40

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

TOP

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

TOP

¦^´_ 14# c_c_lai


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

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

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

TOP

¥»©«³Ì«á¥Ñ HSIEN6001 ©ó 2012-6-15 23:16 ½s¿è

¦^´_ 13# c_c_lai

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


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

TOP

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

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-6-16 08:42 ½s¿è

¦^´_ 16# HSIEN6001
©p¤w«Ø¥ß¦n¸ê®Æ®w¤F¶Ü¡H
03.png
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

TOP

¦^´_ 18# c_c_lai


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

´ú¸Õ.rar (596.82 KB)

TOP

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

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD