SQL Server - Import from Excel

Is there any way that I can get SQL Server to import data from the first sheet within an Excel Spreadsheet.....

I have a DTS package which points to a specifically named sheet (eg Sheet1 as default), but what if Sheet1 doesn't exist (ie named as something else such as mySheet)??? Is there a way to get the DTS to import the first sheet, regardless of its name ???

Thx

You can also use the Enterprise manager to import data from any excel worksheet. Open up the server in Enterprise manager, right-click on it,  and goto all-tasks -> import data. When it asks for the Data Source, choose Microsoft Excel 97-200 (or the appropiate version) from the list, and then browse to the excel file on your computer. Then select where you want the data to goto on the next screen. Eventually you will come to a screen where it will ask you what "tables," or sheets you want to import, select the ones you want, and continue on with the process. Its fairly simple and straight forward. Hope that helps you out.

Andrew is right - I am fully aware and capable of design dts packages to suit my needs.

However, if you want to import from Excel, you have to choose which sheet you want to import from (pretty much in the same way that you choose a table from a db). The problem is that the Excel spreadsheet may not contain 'Sheet1' and therefore this cause the DTS to fail is I implicity define the named sheet.

So, the solution that I am after is a way of importing from the first sheet, regardless of its actual name. I want it to work along the lines of what you can do with a recordset. In other words, if I have a recordset (rs) then I can reference the contained columns by name or by their sequence (0,1,2,3,etc - rs(1)).