I had this exact same error. Try using 'OpenDataSource' instead of OpenRowSet?

It's going to be slower though!

Make sure you specify ';Extended properties =Excel5.0'

or

'Extended properties =Excel 8.0'

based on your needs,...