Wednesday, October 12, 2011 8:12 AM
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
Wednesday, October 12, 2011 8:19 AM
Wednesday, October 12, 2011 8:31 AM
Another option is that the driver is not installed on your server or running on 64 bit. I assume the same path and file is available on your server.
There are 10 type of people. Those who understand binary and those who do not.
Wednesday, October 12, 2011 8:41 AMAnswerer
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.
Wednesday, October 12, 2011 5:48 PMModerator