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.."