Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

Posted on March 2, 2019 By

I was trying to load the content of an xlsx file into a Sql Server database using the “Sql Server import and export wizard” provided by Sql Server Management Studio, and I got the following error “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine”.

The error persisted even after the installation of the Microsoft Access Database Engine from the Microsoft site.

Finally I discovered that Sql Server Management Studio was using the 32 bit version of the Import and export wizard, while on my system I installed a 64 bit version of Microsoft Office and a 64 bit version of Microsoft Access Database Engine.

This seemed to be the issue….

So, as a workaround, you can execute the 64 bit version of the Import and export wizard from the Windows start menu, as follow:

  • click on the Windows Start button
  • type “Import” to search the program
  • click on “Sql Server 2017 Import and export Data (64 bit)”
  • follow the wizard and load the file

Below you can see a screenshot:

Load Sql Server "Import and Export Data"

Hope this helps!

Bye 🙂

Excel, Sql Server

Post navigation

Previous Post: FuelPHP session storage
Next Post: Load a huge amount of data in a Sql Server table

Related Posts

Search a string in stored procedures, functions and views in a SQL Server database Sql Server
Sql Server error using a database with a CLR assembly CLR
How to know who is blocking a query in Sql Server Sql Server
SQL Server LEN function return 0 passing a string with one space Sql Server
Sql Server error: A severe error occurred on the current command.  The results, if any, should be discarded. Sql Server
Zipping xlsx file correctly Excel

Search

Related posts

  • ASP.NET MVC5 Security Exception on Aruba provider
  • Migrating Google GSuite mailboxes to Microsoft Office 365

Categories

  • .NET 6 (1)
  • AJAX (1)
  • Android (2)
  • Apache (4)
  • ASP.NET (9)
  • ASP.NET MVC (3)
  • Avalonia UI (1)
  • BCP (1)
  • Bitlocker (2)
  • C# (14)
  • CentOS (4)
  • ClosedXML (1)
  • CLR (1)
  • DNS (1)
  • Encryption (3)
  • Excel (2)
  • FuelPHP (3)
  • Games (2)
  • Google Chrome (1)
  • GSuite (1)
  • HTML (1)
  • Imagick (2)
  • Javascript (1)
  • Kindle (1)
  • LAMP (3)
  • Linux (6)
  • MariaDB (2)
  • Mathematics (2)
  • MySql (4)
  • NPOI (1)
  • Office 365 (1)
  • Perl (1)
  • PHP (6)
  • Programming (1)
  • Remote desktop (1)
  • SFTP (2)
  • Sockets (3)
  • Sql Server (18)
  • Sql Server 2016 (14)
  • Sql Server 2019 (1)
  • SSL (2)
  • Task scheduler (1)
  • Telerik ASP.NET AJAX (2)
  • The Dummy Programmer Chat (2)
  • The Dummy Programmer Robot (6)
  • Threading (5)
  • Tools (1)
  • TPL (3)
  • TypeScript (3)
  • Ubuntu (4)
  • Virtualization software (3)
  • Visual Studio (1)
  • Visual Studio Code (2)
  • Web fonts (1)
  • Web programming (6)
  • Windows (12)
  • Windows 10 (15)
  • Windows Forms (1)
  • Windows Server (6)

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark