ÇóÒ»¸öÓÃaspÔÚwin2003Öн«Accessµ¹³öµ½ExcelµÄÀý×Ó
±¾À´ÔÚ×Ô¼ºµÄXPϵͳ»ú×ÓÉÏдµÄ³ÌÐò£¬Ò»µãÎÊÌâûÓУ¬µ«Ò»×ªµ½·þÎñÆ÷ÉÏ(Windows2003ϵͳ)¾Í³öÏÖЩĪÃûÆäÃîµÄÎÊÌ⣬¿ªÊ¼ÊÇCreateObject("Excel.Application")²»ÄÜ´´½¨¶ÔÏ󣬲éÁ˰ëÌ죬°ÑDCOMʲôµÄ×é¼þµÄȨÏÞ¶¼ÉèÖúÃÁË£¬¶ÔÏóÄÜ´´½¨ÁË£¬Êý¾ÝÄܵ¹³öÀ´£¬XLSÎļþÒ²ÄÜÉú³É£¬µ«µ¹³öÎļþÒ»Ö±´¦ÓÚÕýÔÚ´ò¿ªµÄ״ֱ̬µ½Timeout£¬¶øÇÒÈÎÎñ¹ÜÀíÆ÷ÖÐÿµ¹Ò»´Î¾Í¶à³öÒ»¸öExcel.exe½ø³ÌºÍDW20.exe½ø³Ì£¬²»ÖªµÀÔõô»ØÊÕ¡£¡£¡£Ö»ÄÜÊÖ¶¯È¥É±µô ÄÄλ´ó¸çÄܸøÒ»¸öÄÜÔÚwindows2003Ͻ«Accessµ¹³öµ½ExcelµÄasp³ÌÐòÀý×Ó£¿ ÄÜÓõÄСµÜÁí¿ªÌùËÍ·Ö¡£¡£¡£¡£
²»Êǽ«±í¸ñµÄÊý¾Ýµ¹µ½Excel£¬Êǽ«AccessµÄÊý¾Ýµ¹µ½Excel£¬ÒªÏÈ·ÃÎÊÊý¾Ý¿â£¬¶Á³öÊý¾Ýºóд½øExcel ¡£¡£¡£ÒýÓà ²»Êǽ«±í¸ñµÄÊý¾Ýµ¹µ½Excel£¬Êǽ«AccessµÄÊý¾Ýµ¹µ½Excel£¬ÒªÏÈ·ÃÎÊÊý¾Ý¿â£¬¶Á³öÊý¾Ýºóд½øExcel ¡£¡£¡£ Äã°Ñ±í¸ñÀïÃæµÄÊý¾Ý¸Ä³É´ÓÊý¾Ý¿â¶Á³öÀ´µÄ²»¾ÍÐÐÁË <% if request.querystring("action")="toExcel" then Response.ContentType="application/vnd.ms-excel" Response.AddHeader "content-disposition","attachment;filename=aaa.xls" end if %> <html> <body> <table name="data" id="data" width="100%" height="25%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%" align="
Ïà¹ØÎÊ´ð£º
ÓÐËÄܸø½²½²£¬Ôõô×öÂ𣿠ллÀ²£¡ ¸ÊÌØÍ¼ ÊÇɶ£¿ ½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ.. ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
ASP.NET MVC¼Ü¹¹·¢²¼ÁË,ÄãÓÃÁËÂ𣿠»¹ÔÚѧϰÖÐ ÎÒÒ²ÔÚѧϰ¡£ÂòÊ飬Ìý½Ì³Ì£¬¿´ÍøÉÏ×ÊÁÏ£¬ÏÂÔØÀý×Ó£¬¸Ð¾õÌý²»´íµÄ£¬²»¹ý±ÈÆð¹¤³§Ä£Ê½£¬ËƺõÑ·É«Á˵㡣¡£¡£»¶Óµ½ÎÒ²©¿Í»¥Ïàѧϰ ¶¼ÓÃÁË5¸ö°æ±¾ÁË ´Ó PV1 µ½beta ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£» QQ£º413763818£» eamil:swebook@126.com ÍøÉÏÒ»´ó¶Ñ£¡ www.51aspx.com ȥϠ......
ÓÐÒ»¸öÀà class adc { dim a,b,c } ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý class getmenber { dim menbers() function getmenbers(resclass) 'resΪһδ֪Àà 'getmenber ......