>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 ?

I would say you need to put both commands into the string and execute them through Execscript.

This is just a guess, I'm not certain.

Thanks.