I am trying to import an XML file which has the following strucutre. It lumps everything after the first tier (order) into one field where I need a field created for each item. I get a table with the fields OrderNumber, OrderDate, Billing, and Address. The Billing and Address fields combine all the data in their tiers. I need fields for each one.

Any ideas?

thanks...

- <Order>
  <OrderNumber>118884</OrderNumber> 
  <OrderDate>7/12/2004 12:00:00 AM</OrderDate> 
- <Billing>
  <FullName>KATHLEEN MAULFAIR</FullName> 
  <Email>THEMAULFAIRS@AOL.COM</Email> 
  <Company /> 
  <Phone>9413507488</Phone> 
- <Address>
  <Street1>8128 NATURES WAY</Street1> 
  <Street2>APT 27</Street2> 
  <City>BRADENTON</City> 
  <State>FL</State> 
  <Code>34202</Code> 
  <Country>United States</Country> 
  </Address>
  </Billing>