Hi Erwin,

As Cetin mentioned, you can use XMLAdapter object to import data from XML document into one or more tables. If you don't have XSD schema or XMLAdapter is not able to parse it, the XMLAdapter.Tables collection can be populated manually or using AddTableSchema method.

Usually, DOM parses XML a lot faster if preserveWhiteSpace property is set to true. Both XMLAdapter and XMLTOCURSOR have similar setting.

Thanks,
Aleksey.


>hi There,
>
>we have an application that reads in some XML files
>using the Microsoft DOM (MSXML2). In our program
>we step through every node and write the data for
>each node to a fox table.
>
>This works fine but takes very long time to complete!
>The XML input files are 20 to 40 Megabytes big, processing
>these files takes about 11 hours!
>
>Can anybody help me with;
>
>1) Is there a faster solution to import XML files into foxpro?
> --> The XML input files contain three or four levels, importing
> them with CURSORTOXML does not work because the output is a
> foxpro cursor with only the first level in fields and the rest
> foxpro puts into a memo field.
>
>2) is there any other solution to import XML in foxpro?
>
>3) is there a way to spead-up XML DOM?
>
>4) Any other suggestions?
>
>Hope anybody can help!
>
>Cheers,
>
>Erwin