The single quote is shown in the output, that is where I am stuck and do not know how to get rid of that single quote (database ='E:\......)

Actually I just made my query little simple to test if its working. but still i am getting the errors below

---------code------------

USE AVME

Declare @SQL nvarchar(MAX)

Declare @docpath nvarchar(MAX)

Set @docpath = N'E:\Workflow\SPP\Attachments\ModelCodes\claim.xls'

Set @SQL...