Here you go
INSERT INTO [BirthDayWish]
([Name],[DOB],[Mobileno],[Weddingday],[Email],[Active])
SELECT [Name],[DOB],[Mobileno],[Weddingday],[Email],[Active] FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=<excel file full path>', [<excel sheetname="">$])
GO
In the above query it is assumed that you are passing an excel file in office 2003 format(.xls). ExcelSheetName is the worksheet name (e.g. say Sheet1) in your excel workbook.