Connecting to MySQL from Microsoft Excel using ODBC Driver for MySQLYou can use Microsoft Excel to access data from a MySQL database using ODBC connector. With ODBC Driver, you can import the data directly into an Excel Spreadsheet and present it as a table. Make sure that you use matching Excel and ODBC Driver, e.g. if you have installed a 64-bit ODBC Drive, you will need to use the 64-bit version of Excel. Show
When working with Microsoft Excel, there are different ways of retrieving data from various data sources using our ODBC drivers:
Connecting Excel to MySQL with Get & Transform (Power Query)You can use Get & Transform (Power Query) to connect to MySQL from Excel with ODBC. This method assumes that you've installed an ODBC driver for MySQL.
If your database is not password-protected or you've already specified your credentials in the ODBC data source settings, select Default or Custom and press Connect The data from the table will be a displayed in an Excel spreadsheet where you can further work with it. Connecting Excel to MySQL with Data Connection Wizard (Legacy Wizard)You can use this option to connect to OLE DB or ODBC external data source that has already been defined.
Connecting Excel to MySQL with the Query WizardYou can use this option to create a simple query for retrieving data from MySQL to Excel via ODBC driver.
Connecting Excel to MySQL with Microsoft QueryYou can use this option to create a more complex query for retrieving MySQL data to Excel via ODBC driver.
Connecting Excel to MySQL with PowerPivotYou can use PowerPivot - an Excel add-in to perform data analysis and create complex data models. To load the required data, do the following:
|