URGENT : Importing XML data into an access database

Guys I know nothing of XML - I dont know the API or objects etc.

The following XML file :

- <Response Version="1.0" xmlns="http://www.dnb.com.au/Schema/CCB/1.0">
- <ConsumerHeader SegId="ERHD01" InternalReference="W9479857-104970-S" UniqueCustomerReference="1234567890" ConsumerId="6779396" Country="AU" ProductName="D&B Individual Public Record Enquiry" NewFileCreated="0" IsMinor="0" HasSummary="1" HasJudgment="1" HasBankruptcy="0" HasSummons="1" HasOtherPublicRecord="0" HasDirector="0" HasFileNote="0" HasDefault="0" HasEnquiry="0" HasError="0" HasWarning="0">
  <EnquiryDate Year="2008" Month="8" Day="25" />
- <PersonName>
  <FirstName>Halama</FirstName>
  <OtherName>Jss</OtherName>
  <Surname>Khan</Surname>
  </PersonName>
  </ConsumerHeader>
- <BestMatch>
- <IndividualDetail SegId="ERID01">
- <Person Sex="U">
- <PersonName>
  <FirstName>Halama</FirstName>
  <OtherName>Jss</OtherName>
  <Surname>Khan</Surname>
  </PersonName>
  </Person>
  </IndividualDetail>
- <Summary SegId="ERSM01">
  <SummaryItem SegId="ERSM01" Sequence="1" Type="JudgmentCount" Count="3" />
  <SummaryItem SegId="ERSM01" Sequence="2" Type="SummonsCount" Count="1" />
  <SummaryItem SegId="ERSM01" Sequence="3" Type="BankruptcyCount" Count="0" />
  <SummaryItem SegId="ERSM01" Sequence="4" Type="OtherPRNoticeCount" Count="0" />
  </Summary>
- <Judgments>
- <Columns>
  <Column Name="DateLodged" />
  <Column Name="ActionTypeDesc" />
  <Column Name="Creditor" />
  <Column Name="Court" />
  <Column Name="Status" />
  <Column Name="Amount" />
  <Column Name="PlaintiffNumber" />
  <Column Name="PlaintiffName" />
  <Column Name="DatePaid" />
  <Column Name="Comments" />
  </Columns>
- <Judgment ActionTypeDesc="Magistrates Court Judgements - Brisbane" Creditor="" Court="Magistrates Court" Status="" PlaintiffNumber="2043/07/QBNE" PlaintiffName="Brisbane City Council">
  <DateLodged Year="2007" Month="4" Day="24" />
  <Comments />
  <Amount Value="2872.0000" />
  </Judgment>
- <Judgment ActionTypeDesc="Magistrates Court Judgements - Brisbane" Creditor="" Court="Magistrates Court" Status="" PlaintiffNumber="3900/05/QBNE" PlaintiffName="Brisbane City Council">
  <DateLodged Year="2005" Month="7" Day="21" />
  <Comments />
  <Amount Value="1072.0000" />
  </Judgment>
- <Judgment ActionTypeDesc="Magistrates Court Judgements - Brisbane" Creditor="" Court="Magistrates Court" Status="" PlaintiffNumber="15961/03/QBNE" PlaintiffName="Brisbane City Council">
  <DateLodged Year="2004" Month="3" Day="2" />
  <Comments />
  <Amount Value="1839.0000" />
  </Judgment>
  </Judgments>
- <Summonses>
- <Columns>
  <Column Name="DateLodged" />
  <Column Name="ActionTypeDesc" />
  <Column Name="Creditor" />
  <Column Name="Court" />
  <Column Name="Status" />
  <Column Name="Amount" />
  <Column Name="PlaintiffNumber" />
  <Column Name="PlaintiffName" />
  <Column Name="DatePaid" />
  <Column Name="Comments" />
  </Columns>
- <Summons ActionTypeDesc="District Court Claims - Brisbane" Creditor="" Court="Magistrates Court" Status="" PlaintiffNumber="695/06/QBNE" PlaintiffName="Finance Express (Qld) P/L">
  <DateLodged Year="2006" Month="3" Day="13" />
  <Comments />
  <Amount Value="47500.0000" />
  </Summons>
  </Summonses>
  <OtherPublicRecords />
  <Bankruptcies />
  <Directorships />
  </BestMatch>
- <Trailer>
  <Disclosure>Disclosure Notice The information in this File may not be sold, assigned, reproduced or copied in any form whatsoever without the prior written consent of DBCC Pty Ltd and/or DBCC (NZ) Ltd (DBCC). The information is protected by copyright, all rights reserved. By accepting this File you acknowledge: * the information in this File may in whole or in part represent or be based on information provided to DBCC from third parties, public registers or publicly available information sources; * information in this File may not be all the information DBCC holds on the relevant individual; * DBCC does not and cannot guarantee or warrant the correctness, completeness, merchantability or fitness for a particular purpose of any information in this File. Such information is to be considered current within DBCC established procedures for updating information and usually is not the product of independent investigation prompted by any enquiry (whether by you or another person); and * that every business decision, to some degree or another, represents an assumption of risk and that DBCC in providing information does not and cannot underwrite your risk in any manner whatsoever. This File is provided on the terms and conditions in the Agreement between you and DBCC under which this File is supplied. Without limiting those terms and conditions, this means that you agree to comply with the privacy laws in respect of any information in this File.</Disclosure>
  </Trailer>
  </Response>

I need to how to cycle through (ie using a for ... next loop to extract the data from the following sections

ConsumerHeader
Judgments
Summonses

Sample code should simply print a line of data for each record found ...

Well commented coding will assisst me to learn quicker.

MTIA

Darrin

PS The objective will be to move the data eventually across to a db, but for the moment, I am content with being helped to extract the data and simply print it to the browser window ....Start Free Trial