title: Unable to read data from excel 2007 file
body: <p>I am trying to import data from excel file (.xlsx) into sql database, my problem is that i am always getting the error "The '<code>Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine</code>", please note that before telling me to search for this error read the below:</p>
  
  <ol>
  <li>my connection string is as follows: <code>string connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelUploadLocation + fileName + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\"";</code></li>
  <li>I installed AccessDatabaseEngine.exe from here: <a href="http://www.microsoft.com/download/en/details.aspx?id=13255" rel="nofollow noreferrer">http://www.microsoft.com/download/en/details.aspx?id=13255</a></li>
  <li>the process is working on my pc (windows 7 32 bit) but not working on the server (windows server 2008 R2 64bit)</li>
  <li>I can't change the target platform from VS 2008 (from any cpu to x86) as you can see in the image below
  <img src="https://i.stack.imgur.com/KYm1X.jpg" alt="enter image description here"> </li>
  </ol>
  
  <p>Any help would be highly appreciated.</p>