把表名和excel路径作为存储过程的变量传入, 内部通过动态SQL处理.
CREATE PROC testProc @tableName VARCHAR(99),@excelRoute VARCHAR(99)
ASDECLARE @strSql AS NVARCHAR(MAX);
SET @strSql =
'SELECT * into @tableName from
OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 5.0;HDR=YES;DATABASE=@excelRoute'',sheet1$)
';
SELECT @strSql = REPLACE(REPLACE(@strSql,'@tableName',@tableName),'@excelRoute',@excelRoute);EXEC sp_executesql @strSql;
CREATE PROC testProc @tableName VARCHAR(99),@excelRoute VARCHAR(99)
ASDECLARE @strSql AS NVARCHAR(MAX);
SET @strSql =
'SELECT * into @tableName from
OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 5.0;HDR=YES;DATABASE=@excelRoute'',sheet1$)
';
SELECT @strSql = REPLACE(REPLACE(@strSql,'@tableName',@tableName),'@excelRoute',@excelRoute);EXEC sp_executesql @strSql;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货