ODBC with latest MS Excel

[Mike Hatfield]

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

[Ken Sproul]

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?

[Mike Hatfield]

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!!

[Devon Austen]

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.

[Tom Anderson]

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

[Mike Hatfield]

Hi Devon & Tom,

I see that you found the same solution as I did.
Thanks to all for the responses