CREATE PROCEDURE p_import
AS
Declare @tbname varchar(255)
Declare @file varchar(255)
Exec('select * into '+@tbname+' from OPENROWSET('''+'MICROSOFT.JET.OLEDB.4.0'''+','+'''Excel 5.0;HDR=YES;DATABASE='+@file+''',sheet1$)')
GO
例如:
create proceduer pd_import
@tbname varchar(255),@filename varchar(255)
as
select * into @tbname form OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=@filename',sheet1$)
go