title: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
body: <p>When I run the following commmands in SQL Server 2012</p>
  
  <pre><code> exec sp_configure 'Advanced', 1 RECONFIGURE
   exec sp_configure 'Ad Hoc Distributed Queries', 1 RECONFIGURE
   EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
   EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
  
   SELECT * INTO dbo.Normalization FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=c:\_sandbox\Consolidations.xlsx','SELECT * FROM [Codes and Values$]')
  </code></pre>
  
  <p>I get this error</p>
  
  <blockquote>
    <p>Cannot initialize the data source object of OLE DB provider
    "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".</p>
  </blockquote>
  
  <p>Any idea why?</p>