ÿ´Î´ò¿ªAccess¶¼ÌáʾҪÉèÖÃ
Ϊʲôÿ´Î´ò¿ªAccess£¬¶¼Ìáʾ¡°windows ÕýÔÚÉèÖà microsoft office 2000 standard ¡±£¬´ò¿ªExcelºÍwordûÓÐÎÊÌ⣿
ÎÒÖØÐ°²×°µÄʱºò£¬È·ÈϹ´Ñ¡Á˵쬵«ÊÇ»¹ÊÇÓÐÕâ¸öÌáʾ
ÄÇÄãµÈÅäÖÃÍ꣬Õý³£³öÀ´ACCESS½çÃæ
Õý³£Çé¿öÅäÖÃһϾͿÉÒÔÁË
ÅäÖùýºÜ¶à´ÎÁË£¬µ«ÊÇ»¹ÊÇÓÐÕâ¸öÌáʾ
²Î¿¼ÏÂ
http://topic.csdn.net/t/20031111/14/2449307.html
http://www.redruan.info/soft/?352191.htm
ÎҲο¼¹ýÁË£¬ÖØ×°¹ýoffice£¬»¹ÊÇÓÐÕâ¸öÌáʾ
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
ÎҵijÌÐòÈçÏ£º
Dim Cnn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim myData As String, myTable As String
Dim myFields As Variant, myValue As Var ......