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>
