ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖÐ?
ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡?лл
ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡? н¨µÄWordºÍÒÑÓеÄWordµÄ´úÂë¿Ï¶¨ÊDz»Ò»ÑùµÄ ÕâµãLZ»¹ÐèÒªÖ¸Ã÷ ÒýÓà ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡? ´úÂëºÜ¶à,ËÑһϾÍÐÐ,²»¹ý1Â¥µÄÒѾºÜÏêϸÁË,¶¥Ò»Ï #2Â¥ ÒýÓà ´úÂëºÜ¶à,ËÑһϾÍÐÐ,²»¹ý1Â¥µÄÒѾºÜÏêϸÁË,¶¥Ò»Ï ÔÚACCESSÀïÃæ´æµÄ£¬¶¼ÊDZí¸ñµÄÐÎʽ£¬Ò»ÕÅÕÅÎïÀí±í¡£ÄãÒªµ¼³ö±à¼£¬µ¼³ö³ÉEXCELµÄ²»ÊǸüºÃ£¿£¿ Èç¹ûÓÃEXCELµÄµ¼³ö£¬¾Í¸ü¼Ó¼òµ¥ÁË¡£¼¸ÐдúÂë¾Í¸ã¶¨ Ö§³ÖһϠÒýÓà ÔÚACCESSÀïÃæ´æµÄ£¬¶¼ÊDZí¸ñµÄÐÎʽ£¬Ò»ÕÅÕÅÎïÀí±í¡£ÄãÒªµ¼³ö±à¼£¬µ¼³ö³ÉEXCELµÄ²»ÊǸüºÃ£¿£¿ Èç¹ûÓÃEXCELµÄµ¼³ö£¬¾Í¸ü¼Ó¼òµ¥ÁË¡£¼¸ÐдúÂë¾Í¸ã¶¨ ÒýÓà ´úÂëºÜ¶à,ËÑһϾÍÐÐ,²»¹ý1Â¥µÄÒѾºÜÏêϸÁË,¶¥Ò»Ï ÊÇ2Â¥µÄ,lzµ÷ÊÔµÄÕ¦ÑùÁË µ½wordÖÐÂ¼ÖÆºê£¬È»ºóÔÚVBÖÐÓÃVBAÖ´ÐоÍÐÐÁË¡£ Ö§³Ö¶þÂ¥ 2Â¥µÄ´úÂëÎÒ·ÅÈëVBÖÐÔËÐе½ Set Appword = New Word.Application ÌáÐѱ༴íÎó,ÎÞЧÍⲿ¹ý³Ì,ʲôÔÒò?
Ïà¹ØÎÊ´ð£º
<?php include("adodb/adodb.inc.php"); $db = &NewADOConnection("access"); $access = realpath("Data.mdb"); $dsn = "Provider=Microsoft.J ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡ Ò»´ÎÈ«²¿¶ÁÍê ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
Âé·³¸÷λ°ïæ¿´¿´°¡ ´úÂëÈçÏ£º CoInitialize(NULL); _ConnectionPtr pConn(__uuidof(Connection)); _RecordsetPtr pRst(__uuidof(Recordset)); pConn->ConnectionString="Provider ......