Hi folks
Got a test preview of Office 2024 Pro LTSC from work for testing -- didn't know it even existed - but seems a lot of things only in office/365 since 2019 have been incorporated into this product.
Not sure if this will hit retail though - but note also if you use legacy data connectors such as msquery in excel you'll need to go to files-->options and on the data section enable the connectors - then when you get external data you'll see an extra colum legacy with your microsoft query as before.
Note also you'll need the oracle community OBDC connector for connecting to mariaDB database for this release - if you installed the 32 bit version of office then install the 32 bit connector.
dev.mysql.com
Then all works as before
Office 2024 LTSC preview

and running a query in EXCEL to remote test MariaDB

cheers
jimbo
Got a test preview of Office 2024 Pro LTSC from work for testing -- didn't know it even existed - but seems a lot of things only in office/365 since 2019 have been incorporated into this product.
Not sure if this will hit retail though - but note also if you use legacy data connectors such as msquery in excel you'll need to go to files-->options and on the data section enable the connectors - then when you get external data you'll see an extra colum legacy with your microsoft query as before.
Note also you'll need the oracle community OBDC connector for connecting to mariaDB database for this release - if you installed the 32 bit version of office then install the 32 bit connector.
MySQL :: Download Connector/ODBC
Then all works as before
Office 2024 LTSC preview

and running a query in EXCEL to remote test MariaDB

cheers
jimbo
My Computer
System One
-
- OS
- Windows XP,7,10,11 Linux Arch Linux
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7