SP_CONFIGURE'SHOWADVANCEDOPTIONS',1
RECONFIGURE
EXECSP_CONFIGURE'AdHocDistributedQueries',1
RECONFIGURE
插入的代码：
INSERTINTOdbo.Resources(ResourcesUrl,ResourcesLink,ResourcesText)SELECT*FROMOPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel8.0;HDR=YES;Database=F:\Book1.xls',[sheet1$])
