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 ?
Regards,
Peter J. Kane
Pete