Create a SQL task who’s existing connection is the excel spreadsheet. Remember, the sheet “screwup” is treated like a table so you must drop it and re- create it, so type in “drop table screwup go” and now paste your create table syntax
I tried the above suggestion of wildh and get an error on the drop table:
"Cannot drop table 'Screwup', because it does not exist in the system catalog"
The Excel file was created with the 2 records as described. What am I missing?
To speak algebraically, Mr. M. is execrable, but Mr. C. is
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.]