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?

Terri

tsanta@lsuhsc.edu