Error: The Microsoft.Jet.OLEDB.4.0 provider is not registered on this machine
Author: mikesblack
Creation Date: 1/12/2016 1:33 PM
profile picture

mikesblack

#1
Hi, As I use 64 bit WL, I purchased 64 bit Excel version 2016. Now I have 2 versions of Excel, 2016 and 32 bit 2013. Can you suggest what I will need to download to make the 64 bit WL work with Excel 2016? Is there an extension that will allow me to accomplish this? Can you provide me the links?
Thanks
profile picture

mikesblack

#2
So just after I posted this last message I cut and pasted the data I have from the earlier Excel. Now I am getting the message that the connection string property has not been initialized. I am not sure what I will need to do. Can you help me with this?
profile picture

Eugene

#3
Naturally, you should find suggestions in provider's online guide:

Excel static provider

Version numbers may have changed but the core idea has remained. I don't work with Excel so it's up to you to experiment, though.
profile picture

mikesblack

#4
Thank you Eugene.
profile picture

mikesblack

#5
I attempted to download the 64 bit Microsoft Access Database Engine, but was unable. It seems because I have 32 bit Office Products installed I am unable unless I delete these items. I can't afford to buy a new office package including outlook. I will need to experiment with the 32 bit WL to see if I can make my Excel data available for what I am doing. I thought if I downloaded the 64 bit Excel, I would be able to work around this. If you or someone else on this forum can come by anything new that can help with this that would be great.

profile picture

Eugene

#6
Both 32/64-bit drivers can not be installed and used simultaneously. If a workaround existed, the folks at more focused resources like Office forums and of course StackExchange would've found it. Try asking there.