Sergey --

That example helps a lot ... almost all I need, I guess.

There is one thing I don't understand though. The beginning of each of my orders look like this:

<Order currency="USD" id="yhst-72066342533466-1551">

I understand that 'currency' and 'id' are called attributes. How can I access them as well?

TIA

>Jim,
>
>You can try to build an XSD using Microsoft XSD Inference 1.0 from http://www.gotdotnet.com/team/xmltools/
>Check also Re: Import nested table Message #1150460
>
>>And what if no schema are loaded? I have a test file of something that I am now receiving every day, and it looks like all data, no schema. How do I proceed?
>
>>>The XMLAdapter will create XMLtables for you if XML you loaded has schema. You can conver them to cursors

>>>oXA.LoadXML(...)
>>>FOR i=1 TO oXA.Tables.Count
>>>	oXA.Tables(i).Tocursor()
>>>ENDFOR
>>>