>>>Wish .Net was in play
>
>LOL! Cetin .Net is in play... I'm passing the recordset back from a C# class method. I can do whatever I want with that recordset in C# before it gets passed back via interop to Visual FoxPro... what did you have in mind? Before you answer that please know that I have absolutely no knowledge of what fields will be in the recordset or what their types are. All I know is that everything seems to work with your approach to creating the cursor over in Visual FoxPro from the recordset except for the this one ADVARWCHAR field that has paths in it. I'm assuming it is the forward slashes in the paths that are causing the rs.save() to fail since everything else works great.
Greaatt:)
Before trying anything else DS.WriteXml with sxhema generated XML might be an answer?
Second create a table on the fly with VFPOLEDB (you have schema so you have structure, no?) and fill from yours?
Unfortunately my C# backyard is on my work computer:)
Cetin