We help IT Professionals succeed at work.

“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine” Error in importing process of xlsx to a sql server

I am WELL past the point of frustration.  This used to be an easy error to fix.  Now, it's not.  So, please tell me how.  

Thanks.  

Software Engineer  

“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine” Error in importing process of xlsx to a sql server
Comment
Watch Question

Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:

Well, we'll need a bit more detail as to what the situation is. i.e. what's installed and what's not.


In general, you will probably have to install either the 2007 ACE Engine redistributable or the 2010 one depending on whether you are working in 32 or 64 bit.


The ACE components are no longer available unless you install them.


Jim.

Author

Commented:
That's the thing.  The link for 2007 is gone.  If you go online to look for this, every website and his mother will tell you that the file is not available.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
I'll see if I can't hunt one down.

But you could use the 2010 which is still available as long as you can change the provider string (A2010 is 14, A2007 was 12).

Jim.
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
So I found a download for it here:

https://download.cnet.com/2007-Office-System-Driver-Data-Connectivity-Components/3000-10254_4-75452798.html 

But I also have the files here (25MB) and the two service packs that go along with that (SP2 72MB and SP3 75MB).   I don't think there's any reason why I can't make them available here as they were free to distribute (Cnet has it obviously), but I would want to check first.

Jim.


Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016

Commented:

Author

Commented:
Thank you, to the fullest!  Very much appreciated!