--
加个
HDR=NO
的选项
,
表示第
1
行是数据
,
默认为
YES,
表示第
1
行是字段名
declare @path char(100),@sql char(500);
set @path = '"c:/Finance/account.xls"'
set @sql='insert into test SELECT * FROM OpenDataSource( ''Microsoft.Jet.OLEDB.4.0'', ''Data Source='+rtrim(@path)+';User ID=Admin;Password=;HDR=NO;Extended properties=Excel 5.0'')...sheet1$'
exec(@sql)
declare @path char(100),@sql char(500);
set @path = '"c:/Finance/account.xls"'
set @sql='insert into test SELECT * FROM OpenDataSource( ''Microsoft.Jet.OLEDB.4.0'', ''Data Source='+rtrim(@path)+';User ID=Admin;Password=;HDR=NO;Extended properties=Excel 5.0'')...sheet1$'
exec(@sql)