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 ?