Try something like this in procedure
DECLARE @docpath nvarchar(200)
SET @docpath = 'E:\Workflow\SPP\Attachments\TR\ExcelUpload\claim.xls'
DECLARE @sql nvarchar(1000)
SET @sql = 'INSERT INTO [YourTable] ([Column1], [Column2]) SELECT A.[Column1], A.[Column2] FROM OPENROWSET (''Microsoft.ACE.OLEDB.12.0'', ''Excel 12.0;;Database=' + @docpath + ''', ''select * from [Sheet1$]'') AS A'
exec(@sql)