insert into SqlTablename
select * from openrowset('MSDASQL','Driver=Microsoft.Jet.OLEDB.4.0;SourceType=Excel 5.0;SourceDB=c:\MyData\','select * from [Exceltablename.xls]')
select * from openrowset('MSDASQL','Driver=Microsoft.Jet.OLEDB.4.0;SourceType=Excel 5.0;SourceDB=c:\MyData\','select * from [Exceltablename.xls]')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货