Declare @fn nvarchar(100),@s nvarchar(1000),@p nvarchar(1000);
set @fn = 'C:\Users\Administrator\Desktop\111.xls';
set @s ='''microsoft.jet.oledb.4.0'',''datasource="'+@fn+'";user id=admin;password=;extended properties=excel 8.0''';
set @p = 'select * from opendatasource ('+@s+')...sheet1$'
exec (@p);哪里错了啊 悲剧=。=
set @fn = 'C:\Users\Administrator\Desktop\111.xls';
set @s ='''microsoft.jet.oledb.4.0'',''datasource="'+@fn+'";user id=admin;password=;extended properties=excel 8.0''';
set @p = 'select * from opendatasource ('+@s+')...sheet1$'
exec (@p);哪里错了啊 悲剧=。=
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货