Openxml()

• Sonnie

  Old Hand

  Points: 370

  More actions

  May 6, 2005 at 4:05 pm

  #164201

  I have an xml file like:

   

  <ROOT>

  <LINE>

          <NAME>NAME1</NAME>

          <VALUE>VALUE1</VALUE>

         <productcode>product1</productcode>

  </LINE>

  <LINE>

          <NAME>NAME2</NAME>

          <VALUE>VALUE2</VALUE>

          <productcode>product1</productcode>

  </LINE>

  </ROOT>

  and I want to load into two different tables like:

   

  table 1:

  id         name      value

  1            name1   value1

   

   

  table 2:

  id         name      value

  2           name2   value2

   

  How do I seperately load this into these two tables?

   

  Please help

   

  Kins

• peterhe

  SSChampion

  Points: 11469

  More actions

  May 9, 2005 at 8:59 am

  #557629

  you can parse the xml into a table variable, then insert into the two different tables based on your criteria