asked on
“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'
Thanks.
Software Engineer
“The 'Microsoft.ACE.OLEDB.12.0'
SoftwareMicrosoft SQL ServerSQL
Last Comment
Software Engineer
ASKER
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.
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.
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you, to the fullest! Very much appreciated!
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.