ODBC with latest MS Excel

Started by Mike Hatfield, May 08, 2024, 10:10:34 PM

Previous topic - Next topic

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
Mike H

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?



Ken Sproul
DPI Information Service, Inc.
Pivotal Systems LLC

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

Mike H

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.
Principal Software Engineer for PVX Plus Technologies LTD.

Tom Anderson

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

Mike Hatfield

Hi Devon & Tom,

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