>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.This may be a stupid comment, as I have not used it or tried your code, but I see that you
"use benefittype in 0"
then immediately tries
APPEND BLANK
. But, is your table selected?