How to Connect Excel to MySQL via ODBC

Learn how to configure the ODBC driver and connect to the database from Microsoft Excel using this driver.

Timestamps:
0:00 Introduction
0:08 Step 1 - Connect to a necessary database
0:25 Step 2 - Test the connectivity
0:35 Step 3 - Access data from the database
0:52 Step 4 - Retrieve data from the table

ℹ️ Find more useful information about ODBC Driver for MySQL here: https://www.devart.com/odbc/mysql/

♦️ Download ODBC Driver for MySQL: https://www.devart.com/odbc/mysql/download.html

✅ Subscribe to our channel: / devartsoftware

---

Closed Caption:

in this short video we will show you how
to configure the odbc driver and connect
to the database from Microsoft Excel
using this driver to connect to a
necessary database you need to run an
obbc administrator switch to the system
DSN Tab and click the ad button select
the previously installed driver and
click
[Music]
finish in the dialogue box fill in the
fields with the connection information
to test the connectivity click the test
connection button then click
okay to access data from the database
open Microsoft Excel and follow the
steps click the data expand the get data
dropdown list and select from other
sources from
odbc choose your DSN and click
okay then the Navigator window will
appear to retrieve data from the desired
table select the table and click load
the data from the table will be
displayed in an Excel spreadsheet and it
will be possible to work with them
further
[Music]