petermeachem
Programmer
Totally confused actually.
This is part of an Access programme that reads vehicle data. I have got as far as getting the data back for one vehicle (which was actually fairly painless), part of which looks like this
What I need from this is things like the make is 'AUSTIN MORRIS' and the model is 'MINI 1000'
I have spent a considerable amount of time on this without really getting anywhere. What is the easiest way of doing this without actually spending ages learning about xml.
I have a feeling the answer is going to be something really obvious that I just haven't spotted.
Thank you.
This is part of an Access programme that reads vehicle data. I have got as far as getting the data back for one vehicle (which was actually fairly painless), part of which looks like this
Code:
<EnquiryResponse>
<RequestResults>
<Asset>
<AssetIdentification>
<Vrm>MER280V</Vrm>
<Vin>XL2W2696342A</Vin>
</AssetIdentification>
<AssetConfirmation>
<Description>VIN/VRM Combination is Confirmed</Description>
</AssetConfirmation>
<DVLA>
<Make>
<Code>A8</Code>
<Description>AUSTIN MORRIS</Description>
</Make>
<Model>
<Code>006</Code>
<Description>MINI 1000</Description>
</Model>
<Body>
<Code>01</Code>
<Description>2 Door Saloon</Description>
<Colour>What I need from this is things like the make is 'AUSTIN MORRIS' and the model is 'MINI 1000'
I have spent a considerable amount of time on this without really getting anywhere. What is the easiest way of doing this without actually spending ages learning about xml.
I have a feeling the answer is going to be something really obvious that I just haven't spotted.
Thank you.