title: Excel into SQL Server with Microsoft.ACE.OLEDB.12.0
body: <p>I'm getting the following error when trying to open an Excel file in SQL Server 2008 r2 64-bit:</p>
  
  <pre><code>Msg 7399, Level 16, State 1, Line 1
  The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" 
  reported an error. The provider did not give any information about the error.
  Msg 7303, Level 16, State 1, Line 1
  Cannot initialize the data source object of OLE DB provider 
  "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
  </code></pre>
  
  <p>I'm using the following query:</p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; 
  HDR=NO; IMEX=1; Database=\\filepath\filename.xlsx', 'SELECT * FROM [Sheet1$]')
  </code></pre>
  
  <p>The funny thing is that the DBA can run it without issue.  I've gone through and ran the following queries:</p>
  
  <pre><code>sp_configure 'Show Advanced Options', 1;
  RECONFIGURE;
  GO
  sp_configure 'Ad Hoc Distributed Queries', 1;
  RECONFIGURE;
  GO
  
  EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
  GO
  EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
  GO
  </code></pre>
  
  <p>The account that runs it looks like it has sa access.  What could be causing this issue?</p>