locked
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

    Debate general

  • NOTE: i have found hundreds of threads on this error, yet they all seem to suggest using the 'Microsoft access database engine'. however for whatever reason (even though its made for 64-bit office) this did not work on my machine so i was forced to find an alternate method.

    this resolution works with:

    • 64-bit Windows 7
    • 64-bit MS Office
    • Please reply to this thread if it worked for you so i can make this a full "compatibility list"

     

    trying to connect to an Access database in visual studio but keep getting this error?

    try installing this first: http://www.microsoft.com/download/en/details.aspx?id=13255

     

    however if, like me, that doesnt work for you, try the following method:

    NOTE: this DOES work for office 2010 even though it is for 2007 office, dont ask me why it just does :)

    1. download and install this: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

    2. in VS click add data source, follow the wizard and enjoy! :)

     

    P.S thanks to everyone that helped me at my original thread: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ebb05600-055a-44c4-8cd3-d33a79878b23

    i did give up and tried storing to text files, but oh my god was that a bad choice! so i came back to trying to resolve this and managed to after HOURS AND HOURS of searching.

    this thread is for all of those people being given a hard time connecting to Access databases!

    Please share your opinions/ problems below!



    • Editado MaxJordan91 sábado, 10 de diciembre de 2011 12:53
    sábado, 10 de diciembre de 2011 12:51

Todas las respuestas

  • The second link worked for me 100%

    Win 7 x64 and Office x64.

    Thanks a million for this.

    lunes, 12 de diciembre de 2011 8:50
  • It worked for me too!! The second solution. I don't believe it. I tried everything including hard search on registry!

    Thanks very much..

     

    lunes, 12 de diciembre de 2011 21:03
  • no problem guys :)

    as i say i spent hours trying to find a solution so upon doing so, i felt the need to share it with everyone. i still want to know why it even works!

    martes, 13 de diciembre de 2011 12:23
  • Second link works just fine.. :)

    Thanks.

    jueves, 15 de diciembre de 2011 23:34
  • Well, even installing the non-64-bit (32 bit) version of Access Database Engine 2010 (rather than the 2007 version you suggested) works for me on Windows Server 2008. It is just that the 64-bit version is not working for some mysterious reason!
    jueves, 22 de diciembre de 2011 0:38
  • The second solution worked for me. Thanks a lot. You made my day.
    miércoles, 04 de enero de 2012 18:31
  • This resolved the problem for me, but caused another one.  I had installed Office 2010 64-bit, then installed the AccessDatabaseEngine.exe from the second link, which resolved my original issue.  Then I tried to install Visio 2010 64-bit and it wouldn't let me, displaying a message saying:

    -------------------

    You cannot install the 64-bit version of Office 2010 because you have 32-bit Office products installed.  These 32-bit products are not supported with 64-bit installations:

    Microsoft Office Access database engine 2007 (English)

    If you want to install 64-bit Office 2010, you must uninstall all 32-bit Office products first, and then run setup.exe in the x64 folder.  If you want to install 32-bit Office 2010, close this Setup program, and then either go to the x86 folder at the root of your CD or DVD and run setup.exe, or get the 32-bit Office 2010 from the same place you purchased 64-bit Office 2010.

    -------------------

     

    I haven't tried it yet, but I assume I could uninstall the database driver and then install Visio and then reinstall the database driver, but this is not something I can put end users of my product through.  I'm wondering if I made a grave mistake in basing my application on an Access database.

    - Ian

    sábado, 07 de enero de 2012 21:07
  • it worked for me, but now i get the couldn't find installable ISAM error. 

    everything i can find for that error is for Jet. it seems to be a registry error but i don't know how to fix - any suggestions?

    (win 7, office 2010, vs2010)

    martes, 17 de enero de 2012 16:47
  • I am getting this error when trying to import Excel files to my SQL Server 2008 R2 database. I tried the first method and then the second. The second method took care of the problem. First post I tried, guess I got lucky.

     

    Thank you.

    jueves, 19 de enero de 2012 18:33
  • Hi there,

    Installing the x86 version on the first link did the trick. That's brilliant, thank you.

    domingo, 29 de enero de 2012 17:34
  • I have Windows 2008 R2 Standard Server with 64 Bit OS.

     

    IT installed MS Office 2010 64 bit version and it did not work.

    I installed 1st link and it did not work.

    Then I installed 2nd link and it worked. Strange but true.

    Thanks a lot.

    Jayson.


    • Editado VCFan09 lunes, 06 de febrero de 2012 16:35 to fix link error
    lunes, 06 de febrero de 2012 16:33
  • Hello Max,

    I installed the two files and the error went away.  Win 7, VS 2010, Office 2010 64.

    Thank you for your post!  You saved me alot of time and trouble.

    WD

    miércoles, 08 de febrero de 2012 3:29
  • I seem to still be struggling.

    Trying to add the database from visual studio 2010 on a Win7 & office 2010 64bit

    Im wondering if its due to my database setup.

    In my database i do have 2010 features (including navigation, calculated fields as well)

    Does anyone have these features? Any help would be amazing!

    miércoles, 22 de febrero de 2012 0:51
  • I'm using VS 2010 and the second method worked like a charm. Thank you!
    viernes, 24 de febrero de 2012 5:19
  • tried the second link first (seems the more popular method) and it worked, nice hack.
     64 bit OS and Office
    • Editado prgmr6 lunes, 27 de febrero de 2012 15:06
    lunes, 27 de febrero de 2012 15:05
  • True. The 2nd link works perfectly, even with x64 Office and x64 Windows7.

    Well done & thanks!

    jueves, 01 de marzo de 2012 9:48
  • please update me if any one is getting a new connection in Visual studiio and with what name

    when i installed on XP x64 machine both the versions did not work

    one 32 bit version worked on my laptop which is 32 bit xp os but i am unable to get

    to point to that is add data source using this driver for excel spread sheet  or access database

    there is no entry in data source which states or smells something like excel

    2. in VS click add data source, follow the wizard and enjoy! :)

    all replies are honoured and welcome

    thanks in advance and warm regards

    bye

    sábado, 10 de marzo de 2012 10:05
  • Thanks Max, 

    The second one works for me, it was 200777777777777777

    miércoles, 14 de marzo de 2012 6:05
  • Hi,

    I installed the program but my problem not solved. I've the same error which is "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." What is wrong?

    Win 7 x64 and Office x64.

    Help me pls?

    My Connection String

    OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelPath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\";");

    martes, 20 de marzo de 2012 16:51
  • Seriously?!!?!?

    This is a very perplexing work around. But it works! Thank you.

    miércoles, 21 de marzo de 2012 21:57
  • Second link work's like magic!

    Thanks!

    sábado, 31 de marzo de 2012 18:27
  • Second link fixed this for my friend.
    jueves, 05 de abril de 2012 15:30
  • Worked, thank you!
    lunes, 09 de abril de 2012 23:58
  • This is so nice and as others have commented but i am kinda new to this stuff, please break it down  for me. I'll appreciate it. 

    My challenge is that the error comes up on my client's system >> "Microsoft.ACE.OLEDB.12.0" is not registered on the local  machine. but it works perfectly on my system. Thanks


    Goody-Christ

    martes, 10 de abril de 2012 10:43
  • I received this error when using SQL Server Management Studio and attempting to import data into a SQL Database.  I selected Microsoft Excel as my data source,  the highest Excel Version that I can select is 2007.   When attemting to go to the next page of the wizard I receive the error message in your post.   

    I have downloaded and installed the second link to my Windows 7 x64 bit workstation and it solved my problem.   When I go directly to the SQL server 2008 r2 running on a Windows 2008  and bring up SSMS and get the same error again.  So it looks as if you need to install this fix on every maching that you will be running SSMS on,  even if it is the server.  

    jueves, 19 de abril de 2012 14:43
  • Thank you very much...

    Second link has absolutely worked for me......... 

    Thanks again... :)

    lunes, 23 de abril de 2012 5:41
  • Thanks MaxJordan91,

    Second point also wored for me. It save me.

    Here is the sequence of operation i performed.

    IIS Pool configured to the 32 bit.

    Error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. Solution: So downloaded from the link and installed.
    http://www.microsoft.com/en-us/download/details.aspx?id=13255


    Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Solution: So downloaded from the link and installed.
    http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

    Thanks,

    Rakesh Ranjan

    jueves, 10 de mayo de 2012 16:37
  • Step 1 :  Goto Project Menu Project Properties

    Step 2 :  Build

                  Platform target : x86

                  Save

    Try this one..

    Hope this will works..

    Regards Manju K Gowda

    lunes, 14 de mayo de 2012 12:08
  • If you have installed the AccessDataEngine and are still getting the Not Registered error

    AND

    you are running IIS7 on a 64 bit server,

    MAKE SURE

    you have enabled 32-bit applications for the application pool associated with the website.  In IIS,  Right click on the application pool.  In the properties window, the 2nd option from the top is "Enable 32-Bit Applications".  Set it to true.

    jueves, 17 de mayo de 2012 18:36
  • I installed the 2nd link and tried to run my project and again I found that my project was not working.

    But as soon as I used the trick posted by Manju K Gowda ,

    My project started working properly.

    and for this My connection string was something like this

    string filename = "D:\\email.xls";

    OleDbConnection strConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filename + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"");

    Thanks a lot.


    sábado, 19 de mayo de 2012 14:13
  • (Second solution) worked for me - Win7 64 / Office 2010 64.  Thanks- you're a life saver!
    lunes, 04 de junio de 2012 20:29
  • The second link worked great!

    Win 7 X64 and Office 2010

    Thank You.

     
    martes, 05 de junio de 2012 16:13
  • I know you said "this resolution works with:
    • 64-bit Windows 7
    • 64-bit MS Office"

    So my question may be outside the scope of this thread, but what does one do if you have a 64-bit PC running 32-bit Windows 7 N and 32-bit MS Office 2010, and trying to connect to an Access MDB file from a Visual Studio (Visual Basic) program using an ADODB.Connection?  Neither of the above solutions works.  I still get
    "Error 3706: Provider cannot be found" with Provider=Microsoft.ACE.OLEDB.12.0

    Any solution will be greatly appreciated.

    lunes, 11 de junio de 2012 13:21
  • I had the problem on SQL mngt Studio / 64 bit Win7 / 64 Bit Office 2010 importing excel sheets

    Installing the accessdbengine work for me.


    • Editado JAFA martes, 12 de junio de 2012 14:27
    martes, 12 de junio de 2012 14:26
  • I am developing a Winform application in c# 4, .Net 4.0 runtime. My dev platform is Windows 7 64-bits with Office 2010 32-bits,

    I noticed that this error happens when the platform target is set to 'Any CPU'. When the platform target is x86 it works fine.

    I havn't checked what happens if the platform target is set to x64.

    I suspect that a 64-bits application cannot work with the 32-bits Jet ACE driver.

    domingo, 24 de junio de 2012 15:30
  • wired. This link works for my Office 2010/x64 and OS/x64:

    http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

    but the Office 2010 X64 engine does not work!


    sábado, 28 de julio de 2012 7:26
  • wired. This link works for my Office 2010/x64 and OS/x64:

    http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

    but the Office 2010 X64 engine does not work!


    sábado, 28 de julio de 2012 7:27
  • Thanks.

    I am able to run my application.

    viernes, 03 de agosto de 2012 8:28
  • This totally worked for me. I am so happy right now. Thanks a million for caring enough to post your findings. Mucho appreciated!

    • win7 x64
    • office 2010
    • IIS 7.5

    however if, like me, that doesnt work for you, try the following method:

    NOTE: this DOES work for office 2010 even though it is for 2007 office, dont ask me why it just does :)

    1. download and install this: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

    2. in VS click add data source, follow the wizard and enjoy! :)

    Jb-

    viernes, 24 de agosto de 2012 15:05
  • Great!!

    The 2nd link works

    I am using SQL Server 2012 Management Studio , Microsoft Excel 2010 (64 Bit Office 2010)
    / Windows 7 64 bit

    Thanks!!!

    MRod

    martes, 28 de agosto de 2012 22:13
  • Unbelievable :)
    The first link didn't work.
    The second did.

    Environment:
    * Visual Studio 2012 Ultimate (Trial)
    * Office Access 2010 x64
    * Windows 7 Ultimate x64

    Thanks a million!
    -tsemer


    • Editado tsemer jueves, 30 de agosto de 2012 18:54
    jueves, 30 de agosto de 2012 18:53
  • Hi,

    I have installed the program from the second link (http://www.microsoft.com/download/en/confirmation.aspx?id=23734), the first error is gone, but I can't make the connection to Access 2010 files with the extension "accdb".

    In the wizard for creating data connection, I have the following error message: Unrecognized database format "File.accdb".

    For .mdb files, the connection is ok.

    My environment is : Windows Server 2008 R2, VS 2010, MS Office 2010 64 bits

    What can I do now ?



    domingo, 09 de septiembre de 2012 5:24
  • Well done and thanks!  Just got into Db programming and was frustrated with this error until I found your fix.  Thanks very much....but I have to say that it is pretty poor that this even exists

    viernes, 21 de septiembre de 2012 20:41
  • 2nd link worked for me. thank you very much
    jueves, 27 de septiembre de 2012 14:25
  • Second link worked for me.  Importing data from a 2010 Excel file into SQL Server 2008 on Windows 7 64-bit OS.

    Thanks!

    viernes, 28 de septiembre de 2012 18:21
  • The second link worked for me as well. I got Windows 7 64-bit, Office 2010 64-bit, and running SQL Data Tools (also VS 2008 BIDS).

    Hope we won't have an issue like this after the newer version of Office is released.

    Thanks a lot,
    Nachi

    miércoles, 03 de octubre de 2012 12:48
  • Its work for me!!!!!

    Windows 7 Ultimate x64, Office 2010 x64

    Thanks a lot man!!!!!!!!!

    viernes, 05 de octubre de 2012 2:49
  • Second link worked totally fine for me (Windows 7 x64 & Office 2010 x64).

    btw: I don't think it's strange, that you have to use Office 2007, since you are adressing a driver with version number 12 (Microsoft.ACE.OleDB.12.0) which is the version number of Office 2007. I guess it would work with Office 2010 if you would address Microsoft.ACE.OleDB.14.0.

    martes, 16 de octubre de 2012 10:48
  • Second link worked fine for me as well.

    Win 7 x64 and Office x64

    Thanks a lot!

    viernes, 26 de octubre de 2012 7:53
  • The second link worked for me too (smoothly)

    Win 7 x64 and Office x64.

    Thanks a lot

    viernes, 26 de octubre de 2012 16:52
  • this really worked n thanks:)
    miércoles, 31 de octubre de 2012 6:13
  • Worked like a charm! Thank you for the help.
    viernes, 02 de noviembre de 2012 14:01
  • The second link worked for me.

    I am running Win 7 64bit + MS Office 64 bit.

    Thanks!

    martes, 06 de noviembre de 2012 16:44
  • Same here.  The second link worked and got my customer up and running and happy with me again.  :-)
    • Editado TQM Doctor jueves, 08 de noviembre de 2012 18:25
    jueves, 08 de noviembre de 2012 18:25
  • Win 8 Pro x64

    Office 2010 x64

    VS 2010 Ultimate x86

    Second solution worked like a charm!  Your the man, Max!  Thanks for your post.

    martes, 13 de noviembre de 2012 2:29
  • Thanks. The second link worked for me!
    jueves, 15 de noviembre de 2012 7:44
  • the second one is what works. saved me alot of time
    domingo, 18 de noviembre de 2012 7:45
  • I am having the same issue I installed the 2007 Version but now get the "Unrecognized database format "File.accdb"."

    Any Idea how to fix this?

    Thanks

    lunes, 19 de noviembre de 2012 0:54
  • Thanks for sharing , the second link works !

    nice job

    lunes, 26 de noviembre de 2012 14:36
  • Second one works!!

    THANK YOU THANK YOU THANK YOU!!!!

    jueves, 29 de noviembre de 2012 8:48
  • Second method worked for me ...Thanks so much!

     

    domingo, 02 de diciembre de 2012 2:54
  • NOTE: i have found hundreds of threads on this error, yet they all seem to suggest using the 'Microsoft access database engine'. however for whatever reason (even though its made for 64-bit office) this did not work on my machine so i was forced to find an alternate method.

    this resolution works with:

    • 64-bit Windows 7
    • 64-bit MS Office
    • Please reply to this thread if it worked for you so i can make this a full "compatibility list"

    trying to connect to an Access database in visual studio but keep getting this error?

    try installing this first: http://www.microsoft.com/download/en/details.aspx?id=13255

    however if, like me, that doesnt work for you, try the following method:

    NOTE: this DOES work for office 2010 even though it is for 2007 office, dont ask me why it just does :)

    1. download and install this: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

    2. in VS click add data source, follow the wizard and enjoy! :)

    P.S thanks to everyone that helped me at my original thread: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ebb05600-055a-44c4-8cd3-d33a79878b23

    i did give up and tried storing to text files, but oh my god was that a bad choice! so i came back to trying to resolve this and managed to after HOURS AND HOURS of searching.

    this thread is for all of those people being given a hard time connecting to Access databases!

    Please share your opinions/ problems below!



    YOU ARE MY HERO!! 

    I have been fighting with this problem for a long time when trying to debug while importing Excel files to be processed.  I could run it in Beta testing and Production environments, but could not debug there.  THANK YOU SO MUCH!!

    miércoles, 05 de diciembre de 2012 16:22
  • running x64 Win 8 and x64 Office 2013, worked for me.  Awesome, thanks so much!!
    jueves, 06 de diciembre de 2012 20:28
  • See here:

    http://kambiz-na.blogspot.com/2012/12/microsoftaceoledb120-provider-is-not.html

    miércoles, 12 de diciembre de 2012 8:10
  • Chabon  la solución 2 funciono te re agradezco.

    gracias,

    chabon

    jueves, 13 de diciembre de 2012 15:44
  • Thanks second link fixed error with sql 2012
    domingo, 23 de diciembre de 2012 19:54
  • Thanks Max.  I Googled the error and your answer came up second, though the first result was irrelevant.  If it wasn't for those many hours you spent, I'd be spending them myself.  Thanks greatly for posting your solution!

    Glenn


    Glenn T. Kitchen VB.NET Forums

    miércoles, 26 de diciembre de 2012 19:51
  • Thanks for the solution.

    I had to uninstall office 32-bit and Installed office professional plus X64

    Finally it worked 

    viernes, 28 de diciembre de 2012 11:09
  • It worked for me.  In my case I tried to create Excel connection in SSIS using SQL Server Data Tool (SQLServer 2012).  Have to install the access database engine for Office 2007 to make it connect. The error it gave me was "Microsoft.ACE.OLEDB.12.0 is not registered".
    sábado, 05 de enero de 2013 20:32
  • It's work, thx so much
    miércoles, 09 de enero de 2013 6:18
  • Great, thanks for your assistant, I install it ,and it is OK.
    viernes, 18 de enero de 2013 10:46
  • Kudos to you MaxJordan91!

    Have SQL 2012 CU1 on 64-bit Win 2008 R2. Couldn't import Excel data trough Management Studio: rightclick db, tasks, import data. Installed AccessDatabaseEngine.exe (that gives me a 32 bit connectivity package, I think?) from link two and then it worked.

    Thank you for sharing!


    JB

    martes, 29 de enero de 2013 13:07
  • Second link worked for :

    -Windows Server 2008 R2 Enterprise (64-bit)

    -Microsoft Office Professional Plus 2010 (64-bit)

    Thank you very much.

    miércoles, 13 de febrero de 2013 21:37
  • Thanks 

    Second link work for me .

    you save my time


    viernes, 15 de febrero de 2013 7:13
  • I am getting this error when trying to import Excel files to my SQL Server 2008 R2 database. I tried the first method and then the second. The second method took care of the problem. First post I tried, guess I got lucky.

     

    Thank you.

    Same situation here. I used the second method and it's work!

    Thanks for the solutions!

    jueves, 21 de febrero de 2013 2:44
  • YES!! Brilliant! Worked for me.

    Whats bizarre about this solution is on 64-bit Server boxes (2003 and 2008) the "Microsoft Access Database Engine 2010 Redistributable" is all thats needed to fully support older and newer Office files (97-2010). But only on Windows 7 64-bit, even AFTER installing Office 2010 64-bit AND "Microsoft Access Database Engine 2010 Redistributable", it does NOT work! Only after installing the 2007 components does this work. Why?

    I suspect this is tied to the fact those old JET drivers are still being registered on Windows 7, for some reason, for backward compatibility. When the older files are loaded, they are addressed with 4-bit pointers, and use the JET, while Office 10 is 8-bit and its components are not removing the JET references. The OLEDB components on Windows 7, even after Office 10 installation, still point back to the 4-bit 2003 Office JET engine drivers, when they should have been upgraded to 8-bit. I guess the 2007 update fixes that.

    lunes, 25 de febrero de 2013 17:00
  • The second alternative fixed it for me.  Everything was working fine until I upgraded from 32-bit Office 2010 to 64-bit Office 2013; then I started to get the 'provider not registered' errors.  I tried the first option, but that didn't work.  The second option worked like a charm :-).

    Thanks for sharing this solution with the rest of us.

    Terri

    martes, 26 de febrero de 2013 17:38
  • Thanks a lot. Now I dont have to go to the campus to run my program. I wonder how can Microsoft overlook such a simple thing such as making their program backwards compatible...
    lunes, 04 de marzo de 2013 22:24
  • I used the x86 first link. Thinking about it, is logic. I am running an asp.net site compiled for x86 platform. So, I need a x86 version of Acces Database engine . 

    Thank you !
    miércoles, 06 de marzo de 2013 19:29
  • Great...second link working.

    Many thanks

    lunes, 11 de marzo de 2013 13:35
  • The second link works for me as well.  This is "Microsoft Office Professional Plus 2010" 64-bit and Win7 64-bit.

    However, as of my last attempt it appears I have to remove this if I want to install office 2013.

    martes, 12 de marzo de 2013 16:05
  • Manju: Great posting. Could not get it to work even after downloading the

    patches, but your fix did the trick. Thanks!

    jueves, 14 de marzo de 2013 15:52
  • I installed http://www.microsoft.com/en-us/download/details.aspx?id=13255 for reading an xlsm file with "Provider=Microsoft.ACE.OLEDB.12.0" in a C# project but I still got this error message. Then I installed http://www.microsoft.com/en-us/download/details.aspx?id=23734 and the file was successfully read.

    The environment is Windows 7 Pro 64-bit, Visual Studio 2010 Pro and .NET 3.5.



    • Editado Haba7 miércoles, 20 de marzo de 2013 11:32
    miércoles, 20 de marzo de 2013 11:30
  • I am using Windows 7 64 bit OS, Office 2010 64 bit and Visual Studio 2010 32 bit..I installed the .exe from the second link..I have data in excel files that needs to be loaded into tabular model of Sql Server 2012.. I am still getting the error Microsoft.ACE.OLEDB.12.0 is not registered. I dont understand if I need to do any other steps followed by installation of .exe file? what does the step "in VS click add data source" means?

    However, if I use powerpivot i can use the same provider to load the excel files..Can someone help me out what I need to do?

    


    jueves, 21 de marzo de 2013 3:31
  • To get rid of this error message on Windows Server 2008 R2 I had to uninstall existing MS Access Database Engine (maybe it was 32-bit) and install 64-bit version of http://www.microsoft.com/en-us/download/details.aspx?id=13255.

    Arunava0907, see the chapter System Requirements / Note here:
    http://yoursandmyideas.wordpress.com/2011/02/05/how-to-read-or-write-excel-file-using-ace-oledb-data-provider/

    jueves, 21 de marzo de 2013 9:01
  • Thanks the second URL worked for me.

    Initially I had Windows 7 64-bit and MS SQL Server 2012 Developer Edition with MS Office 2010.

    Installing MS Office 2013 - it seems to me - caused the problem.

    martes, 26 de marzo de 2013 20:19
  • second option worked for windows server 2008 thank you very much for such an easy straight forward fix
    martes, 26 de marzo de 2013 22:05
  • I am using Windows 8

    64 bit Office 2013 and the 32-bit driver(AccessDatabaseEngine.exe) from the first link worked!

    jueves, 18 de abril de 2013 14:31
  • Thank you it worked for me.

    I was facing issue while importing data to SQL Server 2008 R2 from and Excel 2007 files. I installed from this link http://www.microsoft.com/download/en/confirmation.aspx?id=23734 and it worked :).

    Cheers,
    Abdul Qadar


    MIS engineer

    viernes, 19 de abril de 2013 7:58
  • Thanksssssssssssssss a lot. 2nd link works fine for Office 2013.
    martes, 23 de abril de 2013 13:37
  • Thanks Manju K. Gowda. Your above method works fine on VS 2012 with Office 2013. 

    Once again Thank You very much.

    martes, 23 de abril de 2013 13:39
  • I have just resolved this problem on my machine using your method, thank you so much.

    My machine is running Windows 7 Ultimate 64 bit + Office 2013 Professional Plus 64 bit

    viernes, 26 de abril de 2013 15:28
  • I had previously installed the Microsoft Access Database Engine 2010 Redistributable. I installed your second link (2007 Office System Driver: Data Connectivity Components) in an attempt to resolve the issue. That did not work. I still got the The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine message.

    I resolved this error on my Windows 8 64-bit PC by changing the Visual Studio: Build | Platform Target explicitly to X86. I had it set to Any CPU previously.


    lunes, 29 de abril de 2013 12:12
  • I can't belive I forgot that solution! This happened me more than once and I still forget to do that simple setting to overcome that unbeliavable error. I was having the error (actually VS just executed and stopped without giving any error) in Release mode, and the code was working in debug mode. These errors always make me think "why am I insisting working as a developer after facing similar pains for 27 years"! :-)

    Thank you for reminding this solution. I was about to break my laptop!

    viernes, 03 de mayo de 2013 8:34
  • I had similar issue with Win2008R2 x64 and custom program which used new Access format (I'm not a developer of it, so I only had an installer).

    I had installed this:

    http://www.microsoft.com/en-us/download/details.aspx?id=13255

    It didn't work, then I had installed this:

    http://www.microsoft.com/en-us/download/details.aspx?id=23734

    And with two of these (or just the last one) program worked correctly.

    miércoles, 08 de mayo de 2013 9:28
  • Thank you. This link helped. :)
    miércoles, 08 de mayo de 2013 14:51
  • This may help a few people with SSIS I just use OPENROWSET with Excel these days works fine in 64 and 32 IDE or Non-IDE

    SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',  'Excel 12.0;Database=C:\Temp\2010-11-Imports.xlsx', [Sheet1$])


    Geoff Fane

    domingo, 12 de mayo de 2013 8:29
  • I installed Office 2010 64 Bit on a Windows Server 2008 R2 OS.

    Getting this error while trying to debug a legacy ASP.NET 2.0 application, I tried downloading the 32 Bit OLE/DB provider. But that doesn't seem to work.

    You cannot install both Office versions to the same machine:

    Office 32 Bit error

    Above message box reads (basically):

    "You can not install a 32 Bit version of Microsoft Access Database Engine 2010 because a 64 Bit version of Office products is already installed. If you want to install the 32 Bit version of Microsoft Access Database Engine 2010 you must first uninstall the 64 Bit versions of Office products."


    Microsoft Marketing should care for customer feedback on their consumer products, e.g. Windows & Office.


    Have had Windows 8 …  went back to Windows 7.

    • Editado BetterToday miércoles, 22 de mayo de 2013 11:32
    miércoles, 22 de mayo de 2013 11:28
  • Hey, guys just wondering. At this point, is ACE 12 (32/64 bit) installed together with Windows or Office?  I have a ClickOnce VSTO app and we want to make sure ACE 12 is there. Every test we did seems to suggest that it is installed by either Windows or Office 2010 and 2013 (we didnt test 2007). Is there an official documentation out there that can support our claim?

    Thanks

    miércoles, 19 de junio de 2013 18:10
  • I have just been moved to Win 7 64-bit + Office 2010 32-bit, and can now run using the original suggestions plus the Build for x86 suggestion.

    Not sure how this will affect my users, though, so rather concerned.

    jueves, 20 de junio de 2013 13:30
  • Thanks a bunch, buddy. I would have never thought of this solution. It really save a hell of my time...
    jueves, 20 de junio de 2013 14:31
  • Thanks mate.. ;)

    martes, 25 de junio de 2013 7:00
  • hi. I have 64 bit windows but my office 2007 is a 32 bit version. the 64 bit solution does not install since the office is 32 bits and the 32 bit version did not work. i restarted my system, compiled the application again but the error is still there. any idea for this?
    sábado, 06 de julio de 2013 9:58
  • I am surprised that almost everyone ignored this (Mobill14's) solution. After all the above you will have to do this step.

    "

    If you have installed the AccessDataEngine and are still getting the Not Registered error

    AND

    you are running IIS7 on a 64 bit server,

    MAKE SURE

    you have enabled 32-bit applications for the application pool associated with the website.  In IIS,  Right click on the application pool.  In the properties window, the 2nd option from the top is "Enable 32-Bit Applications".  Set it to true.

    "

    • Editado Junior CSharp martes, 16 de julio de 2013 20:10 correction
    martes, 16 de julio de 2013 20:08
  • Yeah, but that wouldn't work in a development environment using WebDev server.

    Microsoft Marketing should care for customer feedback on their consumer products, e.g. Windows & Office.


    Have had Windows 8 …  went back to Windows 7.

    jueves, 18 de julio de 2013 8:18
  • Thx for the second link, it helped me import execl spread sheets to SQL when i was promted this error.

    Have a nice day!

    martes, 23 de julio de 2013 9:57
  • Thanks. I don't know how many times i've had to return to this post when I rebuild my machines. 
    jueves, 25 de julio de 2013 19:23
  • I have win 8 64 bit and office 2013 also 64 . the second link worked for me.
    jueves, 25 de julio de 2013 20:28
  • Worked!

    Thanks a lot
    martes, 30 de julio de 2013 13:55
  • I've Win-8(64)  - Win2008EE(32) and Office 2010(32-Version-for Home) - Office 2007 (32-SE) - it works without the intallation MicrosoftADEngine Redistributable. For Users PC-s with Win7 Prof (64) and Office 2007 (32 - version Stand.) - don't. For OS (Vista or Win7 32bit) - it's all OK. I created a DLL with option anyCPU, and than load in the MainProject. The DLL must load a xlsx-file. If I change for DLL option x86 - then DLL don't load itself on 64-bit OS. I tried to load MicrosoftADEngine Redistributable (32 and 64 - for 2007 and for 2010) - don't work. I made so - per ODBC.

    string connectionStr = (@"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=D:\MyFile.xlsx;");

    jueves, 08 de agosto de 2013 8:08
  • Worked for me. I was trying to import some templates from excel to SQL Server 2008 R2 and the files missing were installed with http://download.microsoft.com/download/f/d/8/fd8c20d8-e38a-48b6-8691-542403b91da1/AccessDatabaseEngine.exe

    Thank you!

    jueves, 08 de agosto de 2013 16:57
  • If You have Windows 64 bit and MS office 32 - you need to uninstall MS Office, than install 64-b AccessDatabaseEngine.exe and than you can any version MS Office (64 or 32). The Message about "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine" - isn't, and use ole12.

    viernes, 09 de agosto de 2013 8:38
  • Thanks Jordan.

    The "23734" does work for VS2012_U3 -> Ofiice 2013 64 bit connection on Server 2012 64 bit. I am still wondering though why MS still didn't have a good implementation for this. The Access 2013 64 bit runtime released by MS didn't manage to work in this regard.

    It appears MS didn't (or I am yet to see MS)  implement connection string using Microsoft.ACE.OleDB.15.0 which ideally is for Office 2013


    lunes, 12 de agosto de 2013 12:08
  • Second link worked

    Win 8.1 Preview x64 and Office 13 x64

    Thanks a lot!


    • Editado lo0pin lunes, 12 de agosto de 2013 20:08
    lunes, 12 de agosto de 2013 20:05
  • The link that you have provided more than 18 months back helped me today in resolving this issue when the environments got abruptly changed.

    The second options makes wonders. Cant thank you enough.

    Regards,

    Saket Kale

    martes, 13 de agosto de 2013 10:41
  • Hey!  This also solved my problem with Microsoft SQL Server Management Studio....  The data import wizard from Excel was broken.

    thanks!!!!

    Microsoft SQL Server Management Studio 11.0.2100.60
    Microsoft Analysis Services Client Tools 11.0.2218.0
    Microsoft Data Access Components (MDAC) 6.2.9200.16384
    Microsoft MSXML 3.0 4.0 5.0 6.0 
    Microsoft Internet Explorer 9.10.9200.16635
    Microsoft .NET Framework 4.0.30319.18051
    Operating System 6.2.9200

    martes, 20 de agosto de 2013 15:24
  • First link worked.

    Windows 8, SSMS 2012, trying to import data from an Excel 2013 to SQL Server 2012


    Hong

    martes, 20 de agosto de 2013 18:47
  • Dude, thanks for this, it worked perfectly.
    jueves, 22 de agosto de 2013 23:56
  • It did not work for me: Win 7 Pro (64bit), Visual Basic 2010, Office 2007 pro - trying to connect to Access database
    sábado, 24 de agosto de 2013 19:12
  • Thank You so much,God Bless You!The second link also worked 4m.

    kbundas

    domingo, 25 de agosto de 2013 0:23
  • Thank this page for solve the problem. 
    domingo, 01 de septiembre de 2013 6:54
  • Worked for me.

    Im using:

    MSOffice 2010 x64

    Win 7 x64

    domingo, 01 de septiembre de 2013 9:31
  • The first and second solution both works for me; I got the non 64-bit versions of Access.

    I was trying to import data from Excel into SQL Server 2012.

    Win 8 x64, Office 2013 x64, SQL Server 2012 x64

    martes, 03 de septiembre de 2013 18:52
  • It worked for me

    I used Win8 x64 and Office 2010 x64.

    Thanks a lot.

    miércoles, 04 de septiembre de 2013 8:40