Tags

, , ,

 

Fix :- Connect your Ms SQL database server  using SQL management studio

            Click on Submit new query and then execute following quries.

           EXEC sp_configure ‘show advanced options’, 1;

           RECONFIGURE;

          RECONFIGURE WITH OVERRIDE;

         EXEC sp_configure ‘Ad Hoc Distributed Queries’, 1;

         RECONFIGURE

 

  select *  FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0’, ‘Excel 12.0;Database=D:\test.xlsx;’, ‘SELECT * FROM [Sheet1$]’)

Advertisements