My query is as following in which i am tryig to exprot dater from sql statement to csv file. Does any one has any clue what am i doing wrong?
Error is: cannot create an instance of ole db provider "microsoft.ace.oledb.12.0" for linked server "(null)".
SQL statement which is throwing this error is:
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM [SheetNames$]')
select * from Company
>Install Microsoft.ACE.OLEDB.12.0 for Windows, 64 bit version on your server.
>Check if you have access to C:\Windows\ServiceProfiles\LocalService\AppData\Local\Temp
>Allow'Ad Hoc Distributed Queries' to be enabled
>SP_CONFIGURE should be as following:
sp_configure 'show advanced options', 1;
sp_configure 'Ad Hoc Distributed Queries', 1;