Error - SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. RRS feed

  • Question

  • User-1499457942 posted


     Below statement is giving error

    insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=D:\testing.xls;',
    'SELECT * FROM [SheetName$]') select * FROM [DB].[dbo].[Tbl_Test].

    Is it possible thru above statement that it should insert data in excel from 4 column.


    Sunday, June 10, 2018 9:42 AM

All replies