22,209
社区成员
发帖
与我相关
我的任务
分享
exec master..xp_cmdshell 'net use z: \\fileserver\全国业务-杂品定额表 test /user:Fileserver\test'
go
select * from
openrowset('Microsoft.ACE.OLEDB.12.0','Excel 12.0;HDR=YES;IMEX=YES;Database=z:\import\test.xls',sheet1$)
go
select * from
openrowset('Microsoft.ACE.OLEDB.12.0','Excel 12.0;HDR=YES;IMEX=YES;Database=\\fileserver\全国业务-杂品定额表\import\test.xls',sheet1$)
go
exec master..xp_cmdshell 'net use z: /delete'
--在sql中映射一下看看
exec master..xp_cmdshell 'net use z: \\fileserver\import "密码" /user:yizhi\administrator'
go
select * from
openrowset('Microsoft.ACE.OLEDB.12.0','Excel 12.0;HDR=YES;IMEX=YES;Database=z:\test.xls',sheet1$)