Here is the Openrowset/Opendatasource Test Script you can use after the above installation.
If you want to read the column headers into the result set (using HDR=NO even though
there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider
the scenario that one Excel file might work fine cause that file's data causes the
driver to guess one data type while another file, containing other data, causes the
driver to guess another data type. This can cause your app to crash.
'Excel 12.0 XML;HDR=YES;IMEX=1Database=c:\install\AgeHeartRate.xls;',
'SELECT * FROM [Sheet1$]');
Select * from opendatasource(
'Excel 12.0 Xml;IMEX=1;Database=c:\install\AgeHeartRate.xls;')...[Sheet1$]