Home Forums SQL Server 2005 Development Loading data from Excel file into SQL table RE: Loading data from Excel file into SQL table

  • January 14, 2011 at 11:38 am

    #1273711

    Here are the steps to allow distributed ad hoc queries:

    sp_configure 'show advanced options', 1

    reconfigure

    sp_configure 'Ad Hoc Distributed Queries', 1

    reconfigure with override

    This should handle the problem.

    Todd Fifield