Use below query:
DECLARE @myfile varchar(255)
DECLARE @stat int
SET @myfile = 'C:\template.xls'
SET @stat = 1
EXEC ('INSERT INTO
OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=' + @myfile + ';'',
''SELECT * FROM [Sheet1$]'')
SELECT * FROM myTable WHERE [status]=' + @stat + '')