How To - Guide to Importing Data from a MySQL Database to Excel using MySQL for Excel
- by Javier Treviño
Fetching
data from a database to then get it into an Excel
spreadsheet to do analysis, reporting, transforming, sharing, etc. is a very
common task among users. There are several ways to extract data from a MySQL database to then import it to Excel; for example you can use the MySQL Connector/ODBC to configure an ODBC
connection to a MySQL…