ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿ÃÇ°ïæ·ÖÎö һϣ¡£¡£¡ ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë XML code: <?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type="text/xsl" href="inc/sq.xsl"?> <Information> <Station> <Company>³¤½</Company> <name>99Õ¾</name> <inflow>30200</inflow> <outflow>30200</outflow> <reslevel>147.72</reslevel> <output>17190</output> <time>2009-08-23 8:00:00</time> </Station> <Station> <Company>»ÆºÓ</Company> <name>33µçÕ¾</name> <inflow>30200</inflow> <outflow>25600</outflow> <reslevel>65.5</reslevel> <output>17789</output> <time>2009-08-24 8:01:00</time> </Station> </Information>
access²»Ö§³ÖxmlÎļþÀàÐÍ,Ö»ÄܶÁ³öÀ´xmlÊý¾ÝÓÃÑ»·insert½øaccess Òª²»¾ÍÉèΪ´ó×Ö¶ÎÀ´µ±×Ö·û´®´æ£¬SQL2005ÀïÓÐXMLÀàÐ͵Ä×ֶΣ¡ÒýÓà access²»Ö§³ÖxmlÎļþÀàÐÍ,Ö»ÄܶÁ³öÀ´xmlÊý¾ÝÓÃÑ»·insert½øaccess Õâ¸öÄܲ»ÄÜ˵Ïêϸµã°¡£¬ÎÒûÓÐ×ö¹ý£¬ÓÐÏêϸµÄ´úÂë¾ÍºÃÁË Õâ¸öÄܹ»Åжϵ±Ç°µÄXMLÎļþ¸üк󣬾ÍÀ´Ñ»·µÄ½«Êý
Ïà¹ØÎÊ´ð£º
vbÖÐÔõôͨ¹ýxmlÀ´½âÎöÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ¡£ û°ì·¨ÓÃXML½âÎöÊý¾Ý¿âµÄ×Ö¶ÎÖµ£¬³ý·ÇÊý¾Ý¿âÖб£´æµÄÊÇXML¸ñʽµÄ×Ö·û´®Îĵµ¡£ XMLÓÃÀ´Õ¹Ê¾²ã´ÎµÄÊý¾Ý¡£ Êý¾Ý¿âÒ»°ãÊǶþάÊý¾Ý¡£ Êý¾Ý¿âÖб£´æµÄÊÇXML×Ö·û´®¸ñʽ£ ......
ÎÊÌâÈçÏ£º ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿ ¸øСµÜÒ»¸ö£¡ °²×°OFFICEʱѡÔñ°²×°ACCESS °²×°OFFICEʱѡÔñ°²×°ACCESS °²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË officeÍêÕ ......
ÎÒÄ¿Ç°±íµÄÅÅÁÐÊÇÉÏÃæÕâÕÅͼÕâÇé¿ö£º ÎÒÏ£Íûµ÷Õû³É£º ÈçºÎ×öÄØ£¿ ¸Õ²ÅÊÔÁËÏ£¬µã¡°¿ªÊ¼¡±--¡°ÊÓͼ¡±--¡°Éè¼ÆÊÓͼ¡±²»ÐÐ PS£ºÎÒÓõÄÊÇaccess 2007£¬ÉÏÃæÕâ¸ö±íÊÇmdb¸ñʽµÄ Ö÷²Ëµ¥£¬ ÊÓͼ ......
ÎÒ°ÑsqlµÄÊý¾Ý¿â»»ÎªaccessÊý¾Ý¿â£¬Ö»ÐÞ¸ÄÁËÁ¬½ÓÎļþ£¬ÆäËüµÄ¶¼Ã»Óиı䣬³öÏÖ´íÎó(0x80004005) 無·¨Ö¸³öµÄ錯誤¡£ function returnrsByParam(strsql,con,cursor_type,lock_type,options) ......