plzz correct if i m worng in anywer else...
alter procedure importExcel
@sheetName varchar(100),
@filePath varchar(100),
@HDR varchar(10)
as
Begin
declare @sql nvarchar(1000)
set @sql='select *from OpenRowSet'
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+']' ')'
exec sp_executesql_sql
end
Error : incorrect syntex near ')'
plzz M.Khan help me.. i stuck in this code science 5 days..