hmhjh
SP_CONFIGURE 'SHOW ADVANCED OPTIONS',1RECONFIGUREEXEC SP_CONFIGURE 'Ad Hoc Distributed Queries',1RECONFIGURE插入的代码:INSERT INTO Resources(ResourcesUrl,ResourcesLink,ResourcesText) SELECT * FROM OPENROWSET('MJOLEDB0','Excel 0;HDR=YES;Database=F:/Bxls', [sheet1$]) 