MariaDB servers Windows client users latest 64bit ODBC driver Added EXCEL screenshot


jimbo45

Well-known member
Pro User
VIP
Local time
12:19 PM
Posts
4,083
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
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 :

Screenshot_20240412_115817.png



Here´s the query into EXCEL

Skjámynd 2024-04-12 121550.png

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
Back
Top Bottom