Hi Terry,
It seem like it would be possible to convert a VFP cursor into an XML stream and place the XML in a blob text type MS SQL field. Likewise, it should be possible to select a row in a MS SQL database that has the blob text field containing the XML, and convert it back into a VFP cursor. You could insert, delete and update the cursor, and then convert the cursor back to XML and save it back to the MS SQL blob field. In this way you could have many VFP tables housed in the MS SQL table in XML format. Seem like it should work.
In this scenario using VFP as the FAT client would be most convenient. The only question in my mind is whether XML would be to costly in terms of efficiency when working with large amounts of data.
Since XML is univerally standardized, you should be able to retrive the XML using most front end languages and work with it in the language of your choice natively.
I'm curious as to what your solution will be. If you solve the problem, be sure and post your solution.
Thanks,
LelandJ