MSSQL - Addhoc Select from An Excel File

To read data from external Excel file:

SELECT *
FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0',
                                        'Excel 12.0;Database=C:\Temp\SomeExcelFile.xlsx;HDR=YES;IMEX=1',
                                        'SELECT * FROM [Sheet1$]')