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

[µo°Ý] SQL¾Ç²ß

[µo°Ý] SQL¾Ç²ß

¤@ª½§ä¤£¨ì¤@¨Ç¤ñ¸û¦nªºSQL½d¨Ò¡A¨Ó¾Ç²ß¡C
«e´X¤Ñ¦bºô¸ô¤W§ä¨ì¤F¤@¥÷¤å¥ó¡A³£¬O¦b¼gSQLªº¡A«Ü¶}ªº¤ß§â¥¦¤U¸ü¦^¨Ó«á¡K¡Kµo²{¤Ö¤F¤@¨Ç¤å¥ó¡A§â¥¦¸É»ô«á¡K¡K¤Sµo²{¤£¯à°õ¦æ¡K¡KÅý§Úı±o«Ü¾Ò´o¡C

·Ð½Ðª©¤Wªº¥ý¶i«ü±Ð¤@¤U¡A«ç»ò¼Ë¤l¤~¥i¥HÅý¥L¹B¦æ©O¡H¡H

¿ù»~»y¥y¡G
  1.     CNN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;hdr=yes;';Data Source=" & ThisWorkbook.FullName
½Æ»s¥N½X
¹q¸£Àô¹Ò¡G
WIN 7 X64
OFFICE 2010

§ä¨ìªº¤å¥ó¦pªþ¥ó¡K¡K

SQL.rar (98.53 KB)

ªì¾ÇVBA¥E¨ìtwbts

¦^´_ 1# play9091


    play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¶Wª©ªº¦^µª¡A¦ý¬O§Ú¥X¿ùªº³¡¤À©M±zµ¹¥X¨Óªº¹Ï¤£¤Ó¤@¼Ë¤]¡I

§Ú¤§«e¤]¸Õ¹L§â¨º­Ó¯Ê¥¢ªº³¡¤ÀÃö±¼¡A¦ýÁÙ¬O¤£¥i¥H¥Î¡K¡K

¥t¥~¡A§Ú¥Îªº¬Ooffice 2010¤£ª¾¹D³o³¡¤À¬O¤£¬O·|¦³®t§O¡H¡H
ªì¾ÇVBA¥E¨ìtwbts

TOP

¦^´_ 3# play9091
³o¤£¬O2010ªºÃö«Y¡A¥i¯à¬OµLªk¦b64¦ì¤¸§@·~¨t²Î°õ¦æªº½t¬G
§ÚWIN7 32¦ì¤¸ Office 2010°õ¦æ®É¡A¤@¤Á¥¿±`¡A³s¤Þ¥Î¶µ¥Ø³£¯à¥¿±`¤Þ¥Î(³o³¡¤À¥i¯à¬O§Ú¸Ë¦³¦hª©¥»Office)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD