Hi folks
Those who connect to MariaDB (MySQL type database system) and retrieve queries from them into EXCEL using the MsQuery function from within EXCEL (Get external data-->from other data-->your MsQuery) need the windows 64 bit MariaDB ODBC driver.
The latest version can be found here :
mariadb.com
Change the OS in the dropdown to Windows 64 bit (if using W11). Change also the connector to ODBC connector.
Currently testing with Office LTSC 2021 (EXCEL) and Windows 11 PRO (insider DEV).
Testing version of MariaDB :

Here´s the query into EXCEL

All working
Note HediSQL is also good for retrieving data but MsQuery via get data directly into EXCEL in one go seems easier and a bit more flexible.
Cheers
jimbo
Those who connect to MariaDB (MySQL type database system) and retrieve queries from them into EXCEL using the MsQuery function from within EXCEL (Get external data-->from other data-->your MsQuery) need the windows 64 bit MariaDB ODBC driver.
The latest version can be found here :

Download MariaDB Connectors for data access & analysis | MariaDB
Download MariaDB Connector/Python, MariaDB Connector/C, MariaDB Connector/J, MariaDB Connector/Node.js, MariaDB Connector/R2DBC, MariaDB Connector/ODBC and more

Change the OS in the dropdown to Windows 64 bit (if using W11). Change also the connector to ODBC connector.
Currently testing with Office LTSC 2021 (EXCEL) and Windows 11 PRO (insider DEV).
Testing version of MariaDB :

Here´s the query into EXCEL

All working
Note HediSQL is also good for retrieving data but MsQuery via get data directly into EXCEL in one go seems easier and a bit more flexible.
Cheers
jimbo
Last edited:
My Computer
System One
-
- OS
- Windows XP,7,10,11 Linux Arch Linux
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7