xml help please

Hi

I have started to get this file from one of our suppliers:-

<?xml version="1.0" standalone="yes" ?>
- <itemDatabase>
- <itemDetail>
  <itemProductCode>ATI-C3D-9250SE-128</itemProductCode>
  <itemManufCode>C3D</itemManufCode>
  <itemShortDesc>CONNECT 3D ATI AGP</itemShortDesc>
  <itemLongDesc>RADEON 9250 SE 128Mb 8X TV CARD</itemLongDesc>
  <itemAnalysisA>VGA CARDS</itemAnalysisA>
  <itemAnalysisB>AGP</itemAnalysisB>
  <itemAnalysisC>ATI</itemAnalysisC>
  <itemPrice>20.13</itemPrice>
  <itemPhysicalQty>112</itemPhysicalQty>
  <itemURL>products_more.php?prod_code=ATI-C3D-9250SE-128</itemURL>
  <itemWeight>0.3</itemWeight>
  <itemImage>ati-c3d-9250se-128.jpg</itemImage>
  </itemDetail>
- <itemDetail>
  <itemProductCode>GA-GV-N52128DS</itemProductCode>
  <itemManufCode>GIGABYTE</itemManufCode>
  <itemShortDesc>GBT NVIDIA AGP</itemShortDesc>
  <itemLongDesc>FX5500 250/330MHZ 128MB DVI</itemLongDesc>
  <itemAnalysisA>VGA CARDS</itemAnalysisA>
  <itemAnalysisB>PCI-E</itemAnalysisB>
  <itemAnalysisC />
  <itemPrice>20.39</itemPrice>
  <itemPhysicalQty>5</itemPhysicalQty>
  <itemURL>products_more.php?prod_code=GA-GV-N52128DS</itemURL>
  <itemWeight>0.55</itemWeight>
  </itemDetail>
  </itemDatabase>

I basically want to try to import this file into say Excel or Access - I need to find a way of doing this.... also when I try to open this file I get an error cannot load the xml schema - any idea what this refers to?
sagarhAsked:
Who is Participating?
 
BradB3030Commented:
I just re-typed it to make the structure more clear for following experts...Should be able to use a DB structure for this without too much trouble

<?xml version="1.0" standalone="yes" ?>
<itemDatabase>
   <itemDetail>
      <itemProductCode>ATI-C3D-9250SE-128</itemProductCode>
      <itemManufCode>C3D</itemManufCode>
      <itemShortDesc>CONNECT 3D ATI AGP</itemShortDesc>
      <itemLongDesc>RADEON 9250 SE 128Mb 8X TV CARD</itemLongDesc>
      <itemAnalysisA>VGA CARDS</itemAnalysisA>
      <itemAnalysisB>AGP</itemAnalysisB>
      <itemAnalysisC>ATI</itemAnalysisC>
      <itemPrice>20.13</itemPrice>
      <itemPhysicalQty>112</itemPhysicalQty>
      <itemURL>products_more.php?prod_code=ATI-C3D-9250SE-128</itemURL>
      <itemWeight>0.3</itemWeight>
      <itemImage>ati-c3d-9250se-128.jpg</itemImage>
   </itemDetail>
   <itemDetail>
      <itemProductCode>GA-GV-N52128DS</itemProductCode>
      <itemManufCode>GIGABYTE</itemManufCode>
      <itemShortDesc>GBT NVIDIA AGP</itemShortDesc>
      <itemLongDesc>FX5500 250/330MHZ 128MB DVI</itemLongDesc>
      <itemAnalysisA>VGA CARDS</itemAnalysisA>
      <itemAnalysisB>PCI-E</itemAnalysisB>
      <itemAnalysisC />
      <itemPrice>20.39</itemPrice>
      <itemPhysicalQty>5</itemPhysicalQty>
      <itemURL>products_more.php?prod_code=GA-GV-N52128DS</itemURL>
      <itemWeight>0.55</itemWeight>
   </itemDetail>
</itemDatabase>
0
 
0h4crying0utloudCommented:


You can try just pasting the text into notepad and save as a .xls file.  Then open with excel.
0
 
rwalpoleCommented:
Depends which version of Excel you are using. If you have Excel 2002 or later you can change the file type in the open dialogue box. Selecting "XML Files (*.xml)" it should open ok. I'm guessing you are using an earlier version of Excel?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.