Hi,
I looking at a assignment where I have a XML document, which I need to parse 
and import data into a non SQL database from at VB syntax like program.

I need some hints on how to do things "best practices examples".
I'm using MSXML as parser and XPath.

I need to read each project into my db, with most of the under elements 
"CATEGORY_CODE" etc. The CATEGORIES needs to be read in some sort of FOR 
loop?

I have the XML loaded and MSXML set as parser, and also Xpath set as 
selectionlanguage, but where do I go from here? :)

Best regards
MW

Hereunder a example of the XML document.

- <TKI>
- <DELIVERY Version="1.1">
  <DELIVERY_DATE>2008-12-24</DELIVERY_DATE>
  <NO_OF_PROJECTS>4</NO_OF_PROJECTS>
- <PROJECTS>
+ <PROJECT>
  <PROJECT_DESC>Redecorating a Farm</PROJECT_DESC>
  <PROJECT_ID>111</PROJECT_ID>
- <CATEGORIES>
- <CATEGORY>
  <CATEGORY_CODE>11</CATEGORY_CODE>
  <CATEGORY_TEXT>Farm</CATEGORY_TEXT>
  <DEV_TYPE_CODE>5</DEV_TYPE_CODE>
  <DEV_TYPE_TEXT>Decorating</DEV_TYPE_TEXT>
  </CATEGORY>
- <CATEGORY>
  <CATEGORY_CODE>16</CATEGORY_CODE>
  <CATEGORY_TEXT>Country joe</CATEGORY_TEXT>
  <DEV_TYPE_CODE>4</DEV_TYPE_CODE>
  <DEV_TYPE_TEXT>Farmer boy</DEV_TYPE_TEXT>
  </CATEGORY>
  <PROJECT_TEXT>Project is a farmer project, an example of 
thought</PROJECT_TEXT>
- <ROLES>
- <ROLE>
  <ROLE_CODE>10</ROLE_CODE>
  <ROLE_TEXT>Constructer</ROLE_TEXT>
  <COMPANY_ID>11</COMPANY_ID>
  <COMPANY_NAME>Farmer house Corp</COMPANY_NAME>
  <ADDRESS>Farmerroad 1</ADDRESS>
  <ADDRESS2 />
  <ZIP_CODE>5555</ZIP_CODE>
  <POSTAL_TOWN>Farmertown</POSTAL_TOWN>
  <PHONE>12345678</PHONE>
  <FAX />
  <URL />
  <E-MAIL />
  </ROLE>
- <ROLE>
  <ROLE_CODE>18</ROLE_CODE>
  <ROLE_TEXT>Window corp</ROLE_TEXT>
  <COMPANY_ID>556</COMPANY_ID>
  <COMPANY_NAME>Window corp Inc</COMPANY_NAME>
  <ADDRESS>Road 4</ADDRESS>
  <ADDRESS2 />
  <ZIP_CODE>6666</ZIP_CODE>
  <POSTAL_TOWN>Town</POSTAL_TOWN>
  <PHONE>98765432</PHONE>
  <FAX />
  <URL />
  <E-MAIL />
  <OFFICIAL_ID />
  <OFFICIAL_ID_LOCAL />
  <VAT_REGISTRATION_NO />
  <MUNICIPALITY_CODE>236</MUNICIPALITY_CODE>
  <MUNICIPALITY_TEXT>Temp</MUNICIPALITY_TEXT>
  <COUNTY_CODE>3855</COUNTY_CODE>
  <COUNTY_TEXT>Ireland</COUNTY_TEXT>
  <COUNTRY_CODE>IR</COUNTRY_CODE>
  <CONTACTS />
  </ROLE>
  </ROLES>
  <SOMEINFO>Hello</SOMEINFO>
  </PROJECT>
- <PROJECT>
...
  </PROJECTS>
  </DELIVERY>
  </TKI>