>Hi All, I have a simple console app that inserts records into a newly created VFP table using the VFPOLEDB driver, I can create and populate the table ok, however , at the end of the run I want to copy the table to an Excel file - my code fails with the error "One or more errors occurred" - the errant code is shown below
>
>
> Command.CommandText = "Select MyTable";
> Command.ExecuteNonQuery(); // this works ok - or at least doesn't produce an error
>
> Command.CommandText = "Copy to MySheet type xls";
> Command.ExecuteNonQuery(); // BOMBS !!!
>
>
>
>any ideas ?
Pete,
That would work with CommandType.StoredProcedure, CommandText = "ExecScript" and parameter "your script".
However, that's somthing that I wouldn't use from within VFP itself:) Instead I'd create a connection to both VFP and Excel and load one reading from the other with something like DataTable.Load(rdrVFP).
Cetin