一个语法错误,大家进来看看
SELECT * into tmptable FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=d:\book1.xls;User ID=;Password=;Extended properties=Excel 5.0')...[Sheet1$]
这句话直接执行就没有问题,可是换成下面这种方式就报错:
declare @filename as varchar(100)
select @filename='d:\book1.xls'
SELECT * into tmptable FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source='+@filename+';User ID=;Password=;Extended properties=Excel 5.0')...[Sheet1$]
提示在+附近有语法错误
///////////////////////////////
怎么解决呀?