Forum Discussion
November 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in
Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transfo...
I have not been able to connect to an Oracle database using Excel 2016 64bit.
Installing Power Query does not work because it says Excel 2016 already includes the functionality.
When the connection failed, Excel directs me to install some Oracle software. I tried:
ODTwithODAC122010.zip. This has an actual installer, and the Excel error changes to "32bit component for a 64bit system"
ODAC122010Xcopy_x64.zip. This has a batch command line installer, and after following all the instructions, it has no effect -- the Excel error does not change.
Any suggestions?