Home Forums SQL Server 2008 T-SQL (SS2K8) Inserting data from excel sheet RE: Inserting data from excel sheet

  • December 22, 2014 at 9:09 pm

    #1766109

    To execute OPENROWSET commands successfully we need to enable Ad Hoc Distributed queries since by default it will be turned off

    To configure this follow the following:

    sp_configure ‘show advance option’, 1

    GO

    RECONFIGURE

    Afer executing the above, now configure Ad Hoc Distributed queries

    sp_configure ‘Ad Hoc Distributed Queries’, 1

    GO

    RECONFIGURE