accessÊý¾Ý¿â±¸·ÝÓï¾ä
dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;Server=192.168.41.265;User ID=hond;Password=hon52^;Database=200812_honda"
conn.execute "backup database 200812_honda to disk='E:\InetPub\wwwroot\520.mdb'"
Õâ¾äΪʲô³ö´í ÊDz»ÊÇÊý¾Ý¿âÃûÊÇÊý×Ö¿ªÍ·µÄÔÒò£¿Çë¸ßÊÖÖ¸½Ì¸ÃÔõô×ö{{
Ïà¹ØÎÊ´ð£º
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
ÎÒÔÚaccessÖд´½¨Ò»¸ö±í..ÎÒÔõô»ñÈ¡ËûµÄ´´½¨Óï¾ä..
ÎÒÖ÷ÒªÊÇÏë»ñÈ¡ËûµÄ´´½¨Óï¾äÓÃÓÚCMSµÄ°²×° »òÕßÔÚsqlserverÖа²×°ÓÃÓÃ..
VB code:
CreateDatabase Method Example
This example uses CreateDatabase to ......