1You can also use OPENROWSET to import excel file in sql server.
2
3SELECT * INTO Your_Table FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
4 'Excel 12.0;Database=C:\temp\MySpreadsheet.xlsx',
5 'SELECT * FROM [Data$]')