Hi Steve,

I would work with VFP OLE DB provider the same way as with SQL Server, use set oriented SQL commands (Insert, Update, Delete) or create Recordset and use it to update VFP table.


>The following code works in the VFP7 Command Window. I tried to 'port it to VBScript and it does not work. However, the APPEND command is supported by the OLEDB driver, according the MSDN.
>
>

>Set oConn = CreateObject("ADODB.Connection")
>oConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source=c:\wintemp\ttdata\ttdata.dbc"
>oConn.Open
>oConn.Execute("use benefittype in 0") 'benefittype is an existing table
>oConn.Execute("append blank ")
>

>Error message:
>Microsoft OLE DB Provider for Visual FoxPro: One or more errors occurred during processing of command.