Menu
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.
493
The 32-bit and 64-bit versions of Office programs aren't compatible, so you can't install both on the same computer. You're developing in-house solutions, like add-ins or document-level customization. Your organization requires that Hardware Data Execution Prevention (DEP) be enforced for Office applications.
To check whether the 32-bit Microsoft Access Database Engine drivers are installed, go to C:\Windows\SysWOW64\odbcad32.exe. If on a 32-bit machine, go to C:\Windows\System32\odbcad32.exe to access the utility.
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
77
This solution no longer works. It seems to have changed so instead of /passive, now the install requires /quiet
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
