It's an XML generated by MS-Excel 2003, I didn't have that version in my PCs (to be true, I don't have any version of MS-Excel)...
I've try this code:
lcXMLFile = GETFILE("XML")
IF NOT EMPTY(lcXMLFile)
oXMLAdapter = CREATEOBJECT("XMLAdapter")
oXMLAdapter.LoadXML(lcXMLFile,.T.)
?oXMLAdapter.Tables.Count
ENDIF
Can anybody confirm if I can´t process this kind of XML? The company who provide this file is not responding :S...
>It depends on your XML. The XMLAdapter() is also limited in what kind of XML it can process.
>>Thanks sergey, it works, but now I have another issue, as you should expect, now a have a beauty cursor with 7 rows, in this cursor I have a field called Table with all the information in the Worsheet I want to use. It's not necesary to say I'd like the information in that field, obviously as a cursor.
>>So?, do I need XMLAdapter? Or what else I can do?