Thanks Sergey,

Do you know where I can get examples of importing XML using the XmlAdapter?





>The Xmltocursor() can handle XML created by CURSORTOXML() or close to it only. You may consider using XmlAdapter.
>
>>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>
>>