I am trying to read xlsx file through CodeReady which requires ODBC 32bits. When installing MDAC 2010 32 bits on a Windows 10 64 bits, it ended up with a warning.
You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2010:
Microsoft Access database engine 2010 (English)
It seemed to be a nightmare. But the solution was far simple than that. I didn't uninstall everything 64bits. All I need was to install the 32 bits driver in the command line with the magic parameter /passive
AccessDatabaseEngine.exe /passive
It was just as simple as that. It was done nicely without giving me a headache.
It was a happy day!
No comments:
Post a Comment