22,301
社区成员




exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
insert into 表名 select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=excle目标文件',标签名$)
SELECT * INTO 表名 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=文件', 'SELECT * FROM [标签名$]')
'MICROSOFT.JET.OLEDB.4.0'?