Microsoft.ACE.OLEDB.12.0 is not registered

by

Summarized: INSTALL 32 bit version of Microsoft Access Database Engine 2010 Redistributable. Uninstall 64 bit version if previously installed. http://www.microsoft.com/en-us/download/details.aspx?id=13255

The Excel connection manager is trying to use the ACE OLE DB provider in order to access the Excel file when the version is above 2007 (xlsx).
Although your box is 64-bit, you’re using SQL Server Data Tools, which is a 32-bit application. There is no 64-bit version for SSDT. When you design your package within SSDT, you’re using a 32-bit process, which can only use 32-bit providers. When you try to choose the table in the Excel file, the connection manager needs to access the 32-bit version of the ACE OLE DB provider, but this provider is not registered on your machine, only the 64-bit version is installed.

You should download the 32-bit version of the “Microsoft Access Database Engine 2010 Redistributable”. When you try to install it, you might get an error message.
You should first uninstall only the 64-bit version of the “Microsoft Access Database Engine 2010 Redistributable”, which you probably installed previously. The 64-bit version and the 32-bit version can’t live together on the same host, so you’ll have to uninstall (through “Program and Features”) and install the other one if you wish to switch between them.

Once you finish uninstalling the 64-bit version and installing the 32-bit version of the provider, the problem is solved, and you can finally choose the table within the Excel file. The Excel connection manager is now able to use the ACE OLE DB provider (32-bit version) in order to access the Excel file.

More Related Contents:

  1. Import most recent csv file to sql server in ssis
  2. How to create a temporary table in SSIS control flow task and then use it in data flow task?
  3. SSIS – How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename
  4. Parameterized OLEDB source query
  5. SSIS how to set connection string dynamically from a config file
  6. How to load a flat file with header and detail data into a database using SSIS package?
  7. Insert a single row and return its primary key
  8. How to read a flatfile with lowercase thorn as the delimiter
  9. Export Varbinary(max) column with ssis
  10. How to send the records from a table in an e-mail body using SSIS package?
  11. SSIS Package Not Running as 32bit in SQL Server 2012
  12. 2 Data Flow Tasks Linking to one Execute SQL Task
  13. The value violated the integrity constraints for the column
  14. How to convert string in format yyyyMMdd to date using SSIS expression?
  15. How to import a fixed width flat file into database using SSIS?
  16. How to replace double quotes in derived column transformation?
  17. SSIS 2012 – Insert new rows, ignore existing rows
  18. SSIS: script task (vs15) not work when deploy on sql server 2014
  19. How to import text files with the same name and schema but different directories into database?
  20. How to make an HTTP request from SSIS?
  21. SSIS Package not wanting to fetch metadata of temporary table
  22. SSIS Excel Import Forcing Incorrect Column Type
  23. Query a database based on result of query from another database
  24. Running an SSIS Package using dtexec
  25. SSIS Source Format Implicit Conversion for Datetime
  26. How to Map Input and Output Columns dynamically in SSIS?
  27. Reverse engineering SSIS package using C#
  28. Connecting to Oracle Database using Sql Server Integration Services
  29. VS 2015 SSIS Script Tasks cannot be debugged
  30. SSIS Script Task cant find reference to assembly

Leave a Comment