Import Data from Excel to SQL Server using Distributed Queries

SELECT *

FROM   OPENROWSET('Microsoft.ACE.OLEDB.12.0',

       'Excel 12.0 Xml;HDR=YES;Database=C:\Test1.xls',

       'SELECT * FROM [Sheet1$]')

For Better Help see this site

http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm