I'm trying to import a table from an Excel file that I have only read-only access to. There is a nicely formatted table in a tab of the file which has all the data I need, but it is offset in the worksheet (it doesn't start at cell A1). There is also other data in the worksheet outside the table that I would like to exclude.
It seems that all normal import operations for T-SQL assume that you have either one row of headers or no headers at all, and I haven't been able to find a way to reference the Excel table specifically. I've tried using the Import/Export Wizard in SQL Server Management Studio, but it doesn't seem to have the options I need.
What's the best workflow for dealing with this kind of challenge?