导入Execl的一个存贮过程,请帮忙
CREATE proc dbo.SP_ImportS
@vchFilePath varchar(255)
AS
set nocount on
declare @vchProviderStringTemp varchar(255)
declare @nTemp int
declare @vchProviderString varchar(255)
select @vchProviderStringTemp = 'Excel 5.0;HDR=YES;DATABASE= '
--select @nTemp = LEN(@vchProviderStringTemp)
--select @vchProviderString = stuff(@vchProviderStringTemp,@nTemp-1,1,@vchFilePath)
select @vchProviderString = @vchProviderStringTemp+@vchFilePath
drop table student1
GO
select * into Student1 from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0',@vchProviderString,sheet1$)
--,'Excel 5.0;HDR=YES;DATABASE=c:\2002本科生数据.xls',sheet1$)
GO
dbo.sp_imports 'c:\2002本科生数据.xls'
ALTER TABLE student1 ADD password VARCHAR(20) default '1234'
GO
程序老是报:第 2 行: '@vchProviderString' 附近有语法错误。
请高手支着