magicandmight
IS-IT--Management
I have an XML file that was sent to me from a vendor that I need to get into Access 2003. It has a different format then what I usually use when transferring to Access. I have tried my usually import external data to know avail. Anyone know of a way of transferring it without having the vendor change their procedure?
If I change it where each record has only a tag of ie <Individual_In_Network> with the value by itself then close it out as </Individual_in_Network> it gives me know problem but otherwise it only sees element within the table.
<body template="BenefitDocument" reference="Job 12345">
<table name="MaximumsTable">
<Row>
<element name="Individual In Network" value="$1500.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$0.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
<Row>
<element name="Individual In Network" value="$0.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$1500.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
<Row>
<element name="Individual In Network" value="$0.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$0.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
<Row>
<element name="Individual In Network" value="$0.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$0.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
</table>
</body>
If I change it where each record has only a tag of ie <Individual_In_Network> with the value by itself then close it out as </Individual_in_Network> it gives me know problem but otherwise it only sees element within the table.
<body template="BenefitDocument" reference="Job 12345">
<table name="MaximumsTable">
<Row>
<element name="Individual In Network" value="$1500.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$0.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
<Row>
<element name="Individual In Network" value="$0.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$1500.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
<Row>
<element name="Individual In Network" value="$0.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$0.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
<Row>
<element name="Individual In Network" value="$0.00"/>
<element name="Individual Out of Network" value="$0.00"/>
<element name="Family In Network" value="$0.00"/>
<element name="Family Out of Network" value="$0.00"/>
<element name="Individual In Network Lifetime" value="$0.00"/>
<element name="Individual Out of Network Lifetime" value="$0.00"/>
<element name="Family In Network Lifetime" value="$0.00"/>
<element name="Family Out of Network Lifetime" value="$0.00"/>
</Row>
</table>
</body>