INSERT INTO [DatabaseName].[dbo].[Table]
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\...\myFile.xls','Select Column1,Column2 from[SheetName$]')
* SheetName is the name you see at the bottom of each excel sheet
default values being Sheet1 etc.
