Thanks, I will look, but if I can't call something via the VFP7 OLEDB provider from VBScript, I can't use it.
Thanks again.
>You can use any of the available ADO recordset to VFP cursor conversion tools for this. In such case you would only need the SQL provider and not the VFP one. May I suggest you use the following UT download (that I posted) :
http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1454 , after you have the cursor just save it as a DBF. Half of the work is done for you in this download which has a test program that can open the specified SQL Server database and loops through all the tables to perform the conversion. Just change and use the connection string for a SQL Server database.
>
>Alternatively you could use the VFPCOM utility from MS.
>HTH