When running this script, I get:
SET @WorkSheet=NULL; SELECT @WorkSheet=CAST(BulkColumn as xml) FROM OPENROWSET (BULK 'M:\HTS\Export\currency.xls', SINGLE_BLOB ) A;
XML parsing: line 0, character 0, unrecognized input signature at line 1
Msg 50000, Level 16, State 1, Procedure uspImportExcelSheet, Line 497
XML parsing: line 0, character 0, unrecognized input signature
Tried a few xls files, all gave the same error.