import data from Excel with dynamic filepath,tablename using stored procedure

plzz help in importing data from excel...i want to import data from excel with all dynamic filenames...here is my script alter procedure a @sheetName varchar(100) @filePath varchar(100) @HDR varchar(100) Begin declare @sql nvarchar(1000) set @sql='select *from OpenDataSourec' set @sql=@sql+'(' 'Microsoft.ACE.OLEDB.12.0' ',' 'datasource='+@filePath set @sql=@sql+';Excel 12.0;IMEX=1:HDR='+@HDR set @sql=@sql+',select *from[' + @sheetName+']' ')' here an error of unclosed quotation mark...plzz help me