Probably the problem is with the format. As in VFP Help:
*------------------------------------------------
Note
The XMLAdapter LoadXML method might not correctly interpret other XML schema formats as produced by other products
*----------------------------------------------------
If you wish, send files to me. I will see whether I can help.
>Hi,
>I have a sample xml file from customer exported from SAP system. He wants us to import it to our system.
>
>I tried to use XMLAdapter to load it, no error but tables.count return 0. Any ideas?
>
>
>loXA = CREATEOBJECT("XMLAdapter")
>loXA.XMLSchemaLocation="c:\schema.xsd"
>?loXA.LoadXML("c:\data.xml", .T., .T.)
>?loXA.Tables.Count
>
>
>Pls advice.
>
>Pls inform me if you need my schema and xml file for testing.
>
>Thank you