ÔõÑùʹvb.net´úÂëÄÜÖØÓÃÓÚ³ÌÐò¡¢access¡¢ÍøÒ³£¿
ÎÒµ±³õÑ¡Ôñvb.net ,ÊǵÀÌý;˵ËüÄܱà³ÌÐò£¬ÓÖÄܱàÍøÒ³½Å±¾£¬»¹ÄÜÓÃÓÚaccess¼°CADµÄVBA£¬
µ«ÏÖÔÚÈ´²»¶®ÈçºÎÈÃ×Ô¼º±àµÄÕâЩ´úÂëͨÓÃÓÚ³ÌÐò¼°½Å±¾¡£¾ßÌåÎÊÌâÊÇ£º
1£¬ÎÒÏÖÔÚÓÃACCESSŪ³öÀ´µÄÄÇЩ´°Ìå¡¢¼°Æä´úÂ룬ÄÜ·ñÖ±½Ó¸´ÖƵ½ÎÒµÄÍøÒ³ÉÏÈ¥£¿
ÒòΪÎÒµÄÍøÒ³ÉÏÐèÒªµÄÊÇͬÑùµÄ¼Èë´°Ìå¼°²éѯ¡£
2£¬ÏÖÎÒ¶ÔÍøÕ¾ÍøÒ³±àдһµã¶¼²»¶®£¬ÒªÅª¶®Ð©ÒÔʲôÑùµÄ·½Ê½£¬»òÕß˵Ҫ¿´Ê²Ã´Ê飬ÄÜ×îºÃµØÖØÓÃÎÒµÄVB¡£NET´úÂ룿
ÎÒÏÖÔھͻáЩvb.net, »áµãACCESS£¬ ʹÓÃVS2008£¬µ«ÐèҪŪһ¸öÊý¾Ý¿â·Åµ½¸öÍøÕ¾À¹©¹ÜÄÚµÄÈËÔ±ÉÏÈ¥²é¿´£¬Â¼Èë¡£
3£¬ÎÒ¿´VS2008½¨³öÀ´µÄÍøÕ¾£¬¶¼ÊÇASP¡£NETµÄ£¬ÎÒÓбØҪѧASP¡£NETÂð£¿{{
Ïà¹ØÎÊ´ð£º
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:
Private Function getFile_CMD(filename, filepath) As Bo ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
Ç°ÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.
datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
Ôõô°ÑÒÑÖªµÄÊý¾Ý±£´æ³ÉxmlÎļþ£¬ÏÖÔÚÒÑÖªµÄÊý¾ÝÊÇ
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o=& ......
¸÷λ¸ßÊÖ£¬Ð¡µÜ×î½üÅöµ½Ò»¸öÎÊÌ⣺ÔÏÈдµÄ³ÌÐò´ó¸ÅµÄ˼·ÊÇ£ºÊ×ÏÈwebbrowser´ò¿ªÍøÖ·£¬ÍøÖ·ÏÔʾºó£¬µã»÷ÍøÖ·ÉϵÄijһ¸öÁ¬½Ó£¬µ±webbrowser¼ì²âµ½ÍøÖ·ÒѾÁ¬½Óµ½ÏëÒªµÄµØַʱºò¾Í¿ªÊ¼ÏÂÔØÎļþ£¬µ±ÓÃIE6µÄʱºòÏÂÔ ......