各位大神，最近遇到一個很頭疼的問題，我需要把xml里面的資料用access提取出來并形成標準的電子表格格式，方便分析和資料處理，但一直找不到很好的方法，希望各位大神能夠幫小弟解決下這個問題。非常感謝。
源代碼如下所示：
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<raml xmlns="raml21.xsd" version="2.1">
<cmData id="3221225472" scope="all" type="plan">
<header>
<log action="created" appInfo="NSN BTS Site Manager" appVersion="LNT3.1" dateTime="2014-03-13T17:19:47" user="BTSSM"></log>
<log action="created" appInfo="NSN BTS Site Manager" appVersion="LNT3.1" dateTime="2014-06-26T18:18:00" user="BTSSM"></log>
<log dateTime="2014-06-26T23:18:49" action="export" user="omc"></log>
<log action="created" appInfo="NSN BTS Site Manager" appVersion="LNT3.1" dateTime="2014-06-27T17:42:08" user="BTSSM"></log>
<log action="created" appInfo="NSN BTS Site Manager" appVersion="LNT3.1" dateTime="2014-06-30T15:57:30" user="BTSSM"></log>
<log dateTime="2014-07-01T16:06:03" action="export" user="wuzhen"></log>
<log action="created" appInfo="NSN BTS Site Manager" appVersion="LNT3.1" dateTime="2014-07-02T11:41:27" user="BTSSM"></log>
<log dateTime="2014-07-04T17:36:08" action="export" user="wuzhen"></log>
<log dateTime="2014-07-04T18:08:20" action="export" user="wuzhen"></log>
</header>
<managedObject class="MRBTS" distName="MRBTS-53306" operation="create" version="LNT3.1">
<p name="timeZone">(GMT+8) Asia/Shanghai</p>
<p name="actEthernetSec">false</p>
<p name="resetToTestDedicated">false</p>
<list name="passUnitList"></list>
<list name="unitList">
<item>
<p name="primaryConnection">SMOD1-IF1</p>
<p name="prodCode">472835A</p>
<p name="unitName">FR</p>
<p name="unitNumber">1</p>
<p name="variant">NN</p>
</item>
<item>
<p name="primaryConnection">SMOD1-IF1</p>
<p name="prodCode">472835A</p>
<p name="unitName">FR</p>
<p name="unitNumber">2</p>
<p name="variant">NN</p>
</item>
<item>
<p name="primaryConnection">SMOD1-IF1</p>
<p name="prodCode">472835A</p>
<p name="unitName">FR</p>
<p name="unitNumber">3</p>
<p name="variant">NN</p>
</item>
<item>
<p name="primaryConnection">None</p>
<p name="prodCode">472181A</p>
<p name="unitName">FSM</p>
<p name="unitNumber">1</p>
<p name="variant">F</p>
</item>
</list>
</managedObject>
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/116773.html