ÈçºÎ½«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×Ö·û´®¸ñʽ£ ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý" ²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!! ´ó¼Ò¶¼ ......
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º |/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÈçºÎ½«ExcelÊý¾Ýµ¼ÈëAccessÊý¾Ý¿â? ±íÃû:crk End_rbody_60447848//--> ¸Ã»Ø¸´ÓÚ2009-10-19 10:44:48±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP ......