34,594
社区成员
发帖
与我相关
我的任务
分享
create proc daoru
@path nvarchar(1000)
as
begin
declare @sql nvarchar(max)
select @sql=
'insert into tb_yuanbiao select *from
openrowset(''microsoft.jet.oledb.4.0'',''excel 5.0;hdr=yes;database='+@path+''',sheet1&)'
exec(@sql)
end
create proc daoru
(@filepath varchar(100), --> 文件路径
@filename varchar(100) --> 文件名
)
as
begin
declare @tsql varchar(6000)
select @tsql='insert into tb_yuanbiao select * from '
+' openrowset(''microsoft.jet.oledb.4.0'',''excel 5.0;hdr=yes;database='+@filepath+'\'+@filename+';'', '
+' ''select * from [sheet1$]'') '
exec(@tsql)
end
create proc daoru
(@filepath varchar(100), --> 文件路径
@filename varchar(100) --> 文件名
)
as
begin
declare @tsql varchar(6000)
select @tsql='insert into tb_yuanbiao select * from '
+' openrowset(''microsoft.jet.oledb.4.0'',''excel 5.0;hdr=yes;database='+@filepath+'\'+@filename+';'' '
+' ,''select * from [sheet1$]'') '
exec(@tsql)
end