View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Importing XML Data

Hi, I have a large XML file with tons of data and everytime I try to open or
import it into Excel all I ever get is the Attribute/Type Names and Valuetype
data information but I never get the actual Data/Values of the Attributes.
Info Below.


Here's a sample of what I have...

<AttributeNode TypeName="ID"
ValueType="string"6984684687965456</AttributeNode
<AttributeNode TypeName="Description" ValueType="string"Count
Indicator</AttributeNode
<AttributeNode TypeName="Abstract" ValueType="string" /
<AttributeNode TypeName="Status"
ValueType="string"Complete</AttributeNode
<AttributeNode TypeName="Priority" ValueType="string"Low</AttributeNode
<AttributeNode TypeName="Owner" ValueType="string"TDCKLM</AttributeNode
<AttributeNode TypeName="Owner Organization" ValueType="string"Home
Office</AttributeNode


But I never get the information that's there...

6984684687965456
Count Indicator

Complete
Low
TDCKLM
Home Office



Is there something that I am doing wrong?