Excel Import MySQL Table with ODBC Database Query
Use the Query editor (Power Query) to import a MySQL table into Excel using the ODBC Connector for MySQL. Importing the table in this way allows for automatic refresh.
Download the MySQL ODBC Connector to use with Excel here (make sure you match the architecture to that of your Excel install!): https://dev.mysql.com/downloads/conne...
Written tutorial: https://syntaxbytetutorials.com/excel...
