Hi

I guess I will not be using XML for this process as the files can easly have thousands of records.

Thanks
Simon

>That's correct, see also Thread #669425 Message #669549 Re: XMLToCursor limits
>
>HTH
>
>>Hi
>
>>It appears to me that XMLToCursor is really only useable for a small number of records. For example I had a table with 6600 records in it which needs to be sent to a web server via XML. The XML file is 1.8meg and is easly sent to the web server but using XMLToCursor to save the data back to a Visual FoxPro table is very slow. It takes ~110 seconds to create the temporary cursor on my 2.6ghz workstation. So the web request usually times out before everything is complete. CursorToXML is quite fast since it only took .15sec to create the same XML file.
>
>>The reason I need to do this is that I have client with firewall restrictions that require data synchronization and the only way to do this is to send the complete table to the web site so it can be saved thus updating the data on the server.
>
>>So I am wondering what people are doing if they need to send larger files with more records using XML.
>
>>I have resorted to sending the data as a Zipped DBF which works very nicely.
>
>>Regards,
>>Simon
>
>Simon White
>dCipher Computing