7

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.

Sohaib Akhtar
  • 145
  • 1
  • 3
  • 11
  • Check this post - http://stackoverflow.com/questions/24028775/microsoft-ace-oledb-12-0-is-not-registered – Joe C Jun 08 '16 at 19:38
  • I already check this post ... i have removed the Access engine 64-bit from my laptop and now i am trying to install 32-bit but the issue remains the same. – Sohaib Akhtar Jun 08 '16 at 20:30
  • There is a setting called use 64bit runtime that needs to be set to off. Have you done that? – Joe C Jun 08 '16 at 20:43
  • Nope. Can you please tell me how should i turn it off ? – Sohaib Akhtar Jun 08 '16 at 21:13
  • In visual studio its under project properties. This page has a screenshot https://msdn.microsoft.com/en-us/default.aspx Depending on how you deploy to production there are different methods. This article covers some. http://billfellows.blogspot.com/2015/02/is-my-ssis-package-running-in-32-or-64.html – Joe C Jun 08 '16 at 21:22
  • I'm still facing the same problem, unable to install the 32-bit version of MS Access Engine. – Sohaib Akhtar Jun 08 '16 at 22:06

4 Answers4

16

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

Community
  • 1
  • 1
ldobre
  • 361
  • 2
  • 6
9

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

wilson_smyth
  • 1,202
  • 1
  • 14
  • 39
0

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

Daoki
  • 1
  • 2
  • 5
    Please make more obvious what insight your post provides in addition to existing answers. Currently your post gives an impression of merely saying thanks to the answer which already outlined this solution. – Yunnosch Sep 15 '21 at 05:40
  • @Yunnosch Users < 10 rep do not have the right to comment. This would probably have been a comment elsewise. It was the only way how the user could write something. – questionto42 Sep 18 '21 at 19:31
  • @Yunnosch Or 50, yes. I just wanted to mention the likely cause of such answers. I know how it was as a new user when I could not add comments but I still wanted to add some points, it is not nice :). In this case, the first comment here should refer to the commenting privilege problem and less to the content. It is not the first time that critical comments show little awareness of this. – questionto42 Sep 19 '21 at 12:24
  • @Yunnosch I get your point, that way will win on the long run. And more than that, the answer also might still a little bit indeed, since the full code line is now available in the search results while it would be less obvious just as a comment or spread across two answers. An edit might have been better, but anyway, I withdraw from the field. – questionto42 Sep 19 '21 at 12:36
0

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.

Rashaad
  • 1