I've done nothing with XML at all, but I've been given what looks like a realy simple tasks, though not knowing XML could end up being a big job, but enough waffle.

The job...

I've got and XML document storing data. Simple enough I can following the document easily.

What I've been asked to do is get the information out of the XML file and place it into an SQL2000 database using ASP code.

<?xml version="1.0"?>
<bbs>
<bbsentry type="Request" status="New">
<orgref>Test Company</orgref>
<bbsref>CH-Stre-017</bbsref>
<type>Request</type>
<entrydate>2001-06-01 14:29:30</entrydate>
<updatedate></updatedate>
<deadline>2002-06-01</deadline>
<title>Building a better world</title>
<abstract>A company designed to nothing useful</abstract>
<description>blah blah blah how to do this would be nice</description>
<subjectkey>
<keyword type="subject" code="006001">Health, Wealth</keyword>
<keyword type="subject" code="006001005">Electronic, PC</keyword>
</subjectkey>
<rtdprog></rtdprog>
<orgtype>Computing</orgtype>
<orgsize>50-249</orgsize>
<application>
<appdomain>Medecine, health</appdomain>
<appdomain>PC SCIENCES</appdomain>
</application>
<appdomaincomment></appdomaincomment>
<bbsdeleted>0</bbsdeleted>
<cordis>1</cordis>
<firstname>Joe</firstname>
<name>Bloggs</name>
<phone>+44 191 1234567</phone>
<fax>+44 191 1234568</fax>
<email>[email protected]</email>
<url></url>
<org>Test Company</org>
<irc>IRC North</irc>
<street1>1 No Address</street1>
<street2>No town</street2>
<street3>No city</street3>
<zip>Zip NA</zip>
<city>No Where</city>
<country>England</country>
<thematicgrp></thematicgrp>
</bbsentry>
<bbsentry>
details
</bbsentry>
</bbs>

There are a number of these records in one XML document but this is the basic layout. How can I get each record and also each <subjectkey> I also need to store <keyword code>.

I know this looks a lot and probably is, but please help....