I see that MS Excel - Data - Get Data - Other Sources- MS Query has disappeared from the latest version of Excel.
How do we now run PxPlus ODBC ?
Thanks
Mike,
I just applied the latest updates to Office 365.
My Excel is now showing: Version 2404 (Build 17531.20140 Click-to-Run)
On the Data ribbon the section Get & Transform Data still exists with a Get Data drop-down that contains:
- From File
- From Database
- From Azure
- From Power Platform
- From Other Sources
- Combine Queries
- Launch Power Query Editor...
- Data Source Settings...
- Query Options
Under "From Other Sources" is "From ODBC" among a bunch of other options.
What Version do you have?
Hi Ken, That is true but it doesn't allow the selections from the PxPlus ODBC 32/64 interface.
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
Hi Mike,
The newer option "From Other Sources->From ODBC" will show PxPlus ODBC data sources and you can use it to get at your data. The only exception being if you are using a version of PxPlus ODBC driver older than version 6.
Quote from: Mike Hatfield on May 08, 2024, 10:10:34 PM
I see that MS Excel - Data - Get Data - Other Sources- MS Query has disappeared from the latest version of Excel.
How do we now run PxPlus ODBC ?
Thanks
Mike,
This worked for us:
https://answers.microsoft.com/en-us/msoffice/forum/all/the-excel-microsoft-query-menu-option-has/33158d52-6d06-46a9-b848-9656d9957671
Tom Anderson
Hi Devon & Tom,
I see that you found the same solution as I did.
Thanks to all for the responses :)