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

  • January 15, 2011 at 2:41 pm

    #1273943

    Hi all,

    sp_configure 'show advanced options', 1

    reconfigure

    sp_configure 'Ad Hoc Distributed Queries', 1

    reconfigure with override

    With this script I was able to read from the Excel file. Thank you all for helping me..