Excel is a source for DTS. No need for openrowset either. Just edit the worksheet to make (only) row A the column headers, point to the file after choosing the Excel source in DTS, and DTS creates one table per worksheet.
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."