DROP TABLE Queryto the Event Handlers tab or else it will error the second time it is reRun.
SSIS > VS Import wizard for Excel to table:
- Be sure to only checkmark Results$.
- Be sure to Select Delete table option.
- Be sure to Change Results$ name to Destination table name.
- If there is an error, it is often because a row in Excel has a NULL but the table column is NOT NULL (so add a blank to the Excel field).