|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have XML formed as follows (this is just a part of the XML)
- <players>
- <player id="814090">
<name>Brian</name>
<surname>Bradford</surname>
<countryfrom id="4">USA</countryfrom>
<age>27</age>
<value>587000</value>
<salary>7400</salary>
<cards>4</cards>
<injurydays>0</injurydays>
<matches>48</matches>
<goals>68</goals>
<assists>9</assists>
<form>11</form>
<stamina>9</stamina>
<pace>7</pace>
<technique>4</technique>
<passing>9</passing>
<keeper>0</keeper>
<defender>2</defender>
<playmaker>7</playmaker>
<scorer>9</scorer>
</player>
- <player id="814079">
<name>Jovan</name>
<surname>Broker</surname>
<countryfrom id="4">USA</countryfrom>
<age>27</age>
<value>319000</value>
<salary>4400</salary>
<cards>0</cards>
<injurydays>0</injurydays>
<matches>43</matches>
<goals>0</goals>
<assists>1</assists>
<form>9</form>
<stamina>7</stamina>
<pace>2</pace>
<technique>6</technique>
<passing>6</passing>
<keeper>0</keeper>
<defender>8</defender>
<playmaker>7</playmaker>
<scorer>2</scorer>
</player>
and so on...
My question/problem is that I need to get the ID (player id="814090") out of
it as well as the rest of the data. I successfully import the XML into
Access/VB using ImportXML. But that part of the XML isn't stored (i don't
know if that's a part of a tag or header or what, but it's not stored in the
table when ImportXML is used - everything else is stored however).
Does anyone know how i'd get this out properly?
Thanks in advance,
-ben
|
|
|