• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

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?
0
sagarh
Asked:
sagarh
3 Solutions
 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now