Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»¸öACCESSÊý¾Ý¿â ÄܲåÈ롢ɾ³ý£¬µ«ÊDz»ÄܸüÐÂ

access ÒѽûÓôËÊý¾Ý¿âÖпÉÄÜÓꦵÄÄÚÈÝ vba
ÎÒÓÃaccess´ò¿ªÕâ¸öÊý¾Ý¿âÌáʾ½ûÓÃÁËÕâ¸ö
Èç¹ûÎÒÑ¡ÔñÆôÓà ¾ÍÄܸüÐÂÁË


ÈçºÎÔÚ³ÌÐòÖдò¿ªÊý¾Ý¿âÒ²ÆôÓÃÕâ¸öÄØ£¿

OleDbConnection conn = new OleDbConnection(@"");
  conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath.ToString() + "\\aar.mdb;Persist Security Info=true";
         

UP

Äã°Ñ¸üеĴúÂëÌù³öÀ´  Äã¾ÍÌù¸öÁ´½ÓµÄ´úÂë ¿´²»³öÀ´ ÎÒÓÃACCESSµÄʱºò¶¼Õý³£ ÊDz»ÊÇÄãµÄ´úÂëдµÄÓÐÎÊÌ⣡

ûÓùýaccess

²»ÊǺÜÃ÷°×LZµÄÒâ˼¡£¿ÉÒÔ試ÖøÖ±½ÓʹÓÃSQL語¾ä來¸üÐÂ數據¡£Èç¹ûSQL語¾äÄܸüУ¬ÄÇÄã¾Í±Ø須ºÃºÃ檢²éÄãµÄ¸üдú碼ÁË¡£

ɾ³ýÔÙ²åÈë

²»ÊǺÜÃ÷°×£¬°ïÂ¥Ö÷¶¥£¬µÈ¸ßÊÖ½â¾ö£¡

¶àÊÔ¼¸Ì¨»úÆ÷£¬¿´ÊDz»ÊǶ¼ÓÐÕâÑùµÄÎÊÌ⣬Èç¹ûÖ»ÊǸö±ð»úÆ÷³öÏÖÕâÑùµÄÎÊÌ⣬ÄÇ˵Ã÷ÊDzÙ×÷ϵͳµÄÎÊÌ⣬ÄǾͲ»ÒªÈ¥×êÕâ¶«¶«


Ïà¹ØÎÊ´ð£º

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

access²»ÄÜÐÞ¸ÄÄÚÈÝ

ÈçÌâÔÚÎÒ´ò¿ªaccessÐ޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe      AppVer: 11.0.8166.0    AppStamp:46437912
ModName: pintlgnt.ime&n ......

Äܲ»ÄÜÓÃÒ»ÌõSQLÓï¾ä¸ü¸ÄACCESSµÄ±íÃû£¿

±ÈÈçÏë°Ñ old¸Ä³É new£¬ÔõÃ´Ð´ÄØ£¿
²»ÄÜ£¬ÓÃADO¡¡OR¡¡DAO

or
select * into new from old

£¬ÓÃADO¡¡Õâ¸öÔõô¸Ä£¿

JET-SQL²»ÄܸıíÃû¡£Ö»ÄÜÉú³ÉÒ»¸öеġ£

Ò»°ãÊÇÖ±½Ó

SQL code:
select * ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ