¼±£¡¹ØÓÚEXCELµ¼ÈëACCESSµÄÎÊÌâ
EXCELÖÐÓÐÒ»ÁÐÊý×ÖÈçÏ£º µ¼Èëµ½ACCESSÒÔºó
²ÄÁÏ ²ÄÁÏ
20 20
20 20
20 20
20 20
410II
²»Ðâ¸Ö
20 20
20 20
20 20
ÈçÉÏËùʾ£¬Ö»ÊǽØÈ¡ÁËһС²¿·Ö£¬´óÖ¾ÍÊÇEXCELµ¼ÈëACCESSÒÔºóÖ»ÏÔʾȫÊÇÊý×ֵIJ¿·Ö£¬ÇëÎÊÊÇÔõô»ØÊ£¬¸ÃÈçºÎ½â¾ö¡£ÆäËû²¿·Ö¸ñʽͳһµÄÈ
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
select * from table where [pname]='''+edit1.text+''' ²»ºÃÓÃ
'select * from table where [pname]='+QuotedStr(edit1.text)
Èç¹û×Ö¶ÎÊÇÊý×ÖÐ͵Ä
'select * fro ......
ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)
Dim DDTP1 As String
Dim date1 ......