I am trying to Export data from SQL Sever Table to Exel sheet by using the below query
INTO OPENROWSET ('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=D:\New Folder\New Microsoft Office Excel Worksheet.xlsx;','SELECT * FROM [Test$]')SELECT * FROM [TableName]
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
can you help me on how to resolve the above
HI nmitta !
Try to run and set these setting;
sp_configure 'show advanced options', 1; RECONFIGURE; Go sp_configure 'Ad Hoc Distributed Queries', 1; RECONFIGURE;
Please let me know if this doesn’t work for you. Hope I have answered you correctly.