I have an ASP.NET C# project with uses an OleDbConnection string for Excel (XLSX) files. The connection uses the provider Microsoft.ACE.OLEDB.12.0.
This works fine on my local development (32 bit) server but when I release it into production (presuming it 64 bit by my initial research), I get the error:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Now, I have read that you should target the project specifically to a 32bit but cannot find where you do that using Visual Studio 2008 on projects that use C#.
Any ideas how to overcome this issue?