- Local time
- 7:04 AM
- Posts
- 5,931
- Location
- Hafnarfjörður IS
- OS
- Windows XP,11 Linux Fedora Rawhide pre-release 46
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 :
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
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
Last edited:
My Computer
At a glance
Windows XP,11 Linux Fedora Rawhide pre-releas...2 X Intel i7
- OS
- Windows XP,11 Linux Fedora Rawhide pre-release 46
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7
- Screen Resolution
- 4KUHD X 2
