字段值为空的XML文件如何导入DATAWINDOW

hardwind 2009-11-27 04:32:43

有这样一段由.net生成的xml(由dataset转化而来):

<NewDataSet><xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"><xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"><xs:complexType><xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="Table"><xs:complexType><xs:sequence><xs:element name="ica015_un" type="xs:int" minOccurs="0" /><xs:element name="ica000_un" type="xs:int" minOccurs="0" /><xs:element name="cardno" type="xs:string" minOccurs="0" /><xs:element name="vipno" type="xs:string" minOccurs="0" /><xs:element name="ctype" type="xs:string" minOccurs="0" /><xs:element name="state" type="xs:string" minOccurs="0" /><xs:element name="amt" type="xs:decimal" minOccurs="0" /><xs:element name="enddate" type="xs:string" minOccurs="0" /><xs:element name="venddate" type="xs:string" minOccurs="0" /><xs:element name="lstate" type="xs:string" minOccurs="0" /><xs:element name="ocardno" type="xs:string" minOccurs="0" /><xs:element name="estate" type="xs:string" minOccurs="0" /></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema>
<Table><ica015_un>353</ica015_un><ica000_un>1</ica000_un><cardno>59301800009050002879</cardno><vipno /><ctype>M1-S50</ctype><state>3</state><amt>0.00</amt><enddate /><venddate /></Table><Table><ica015_un>354</ica015_un><ica000_un>1</ica000_un><cardno>59301800009010030988</cardno><vipno /><ctype>M1-S50</ctype><state>3</state><amt>0.00</amt><enddate /><venddate /></Table><Table><ica015_un>355</ica015_un><ica000_un>1</ica000_un><cardno>59301800009010030989</cardno><vipno /><ctype>M1-S50</ctype><state>3</state><amt>0.00</amt><enddate /><venddate /></Table><Table><ica015_un>356</ica015_un><ica000_un>1</ica000_un><cardno>59301800009030031825</cardno><vipno /><ctype>M1-S50</ctype><state>3</state><amt>0.00</amt><enddate /><venddate /></Table></NewDataSet>

通过importstring函数导入的时候因为有些字段为空值,所以会出错,在忽略的情况下导入的数据是错位的,如果设置导入模板,则无任何反应,求救各位高手,大侠.

...全文