在'@EName'附近有语法错误.

[78hgdong]

CREATE PROCEDURE PROCBLtoExcel
@Name varchar(250)
AS
declare @Excel varchar(4000)
declare @EName varchar(1000)

set @EName=N'Microsoft.Jet.OLEDB.4.0'
set @Excel=N'Data Source="D:\Excel2005\'+@Name+N'";User ID=Admin;Password=;Extended properties=Excel5.0;Persist Security Info=false'
select * into #temp2 from OpenDataSource(@EName,@Excel)...[sheet1$] // 提示:在'@EName'附近有语法错误.
不明为何!各位帮帮!TKS!

[78hgdong]

select * into #temp2 from OpenDataSource(@EName,@Excel)...[sheet1$]

// 就是上面这句提示:在'@EName'附近有语法错误.

[ghostzxp]

CREATE PROCEDURE PROCBLtoExcel
@Name varchar(250)
AS
declare @Excel varchar(4000)
declare @EName varchar(1000)
declare @sql varchar(1000)

set @EName=N'Microsoft.Jet.OLEDB.4.0'
set @Excel=N'Data Source="D:\Excel2005\'+@Name+N'";User ID=Admin;Password=;Extended properties=Excel5.0;Persist Security Info=false'
set @sql=N'select * into #temp2 from OpenDataSource('+@EName+','+@Excel+')...[sheet1$]'
exec sp_executesql @sql

[78hgdong]

请问怎么查询#temp2 的返回值了????

[Navywang917]

select * into #temp2 from OpenDataSource(@EName,@Excel)...[sheet1$]
这里没用到参数！
改为exec('@sql=N'select * into #temp2 from OpenDataSource('''+@EName+''','''+@Excel+''')...[sheet1$]'')