Here is the Openrowset/Opendatasource Test Script you can use after the above installation.

/*

Ref: http://www.connectionstrings.com/excel-2007

If you want to read the column headers into the result set (using HDR=NO even though

there...

I recently came across this problem when we moved from Windows 32bit to Windows 64bit, using SQL 2005/2008 64bit. There are a lot of openrowset/opedatasource for older Excel 2003...