How to install Microsoft.Ace.oledb 32 bit with Office 64-bit?

Question

I was trying to create a SSIS package where i want to upload an excel file into my DB but its giving me an error that

Microsoft.ACE.Oledb.12.0 is not registered on your local machine

I have installed the 64-bit version of the MS Access Engine and it perfectly installed but after that i am still unable to create DTS package. I have searched over the internet and found that there are two versions available for this and i have downloaded both and when i try to install the 32-bit version of the Access Engine it gives me error

You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed.

Please help me on this i am really looking forward to it.

Answer 1

I'm having this issue to and I tried to use the /quite but it's stating that The system cannot find the path specified.

Answer 2

This solution works when installing ACE 32bit on with 64bit Office $yourPath$\AccessDatabaseEngine.exe /quiet Thank you sir

Answer 3

This solution no longer works. It seems to have changed so instead of /passive, now the install requires /quiet

Answer 4

Somehow late to the party but nevertheless:

source

To install the Microsoft ACE OLEDB Provider 32-bit on a machine running Office 2010 64-bit: install using cmd with the following command:

$yourPath$\AccessDatabaseEngine.exe /passive