Connect to MySQL from Excel (Complete Guide)

Add to Favorites
Author: | Edits: don

How to connect to a MySQL database from Excel, fetch the latest data from it, and work with that data inside your spreadsheets in Excel.

This tutorial is step-by-step and shows you how to do everything, from downloading the ODBC drivers (explained in the tutorial) to importing and transforming the data from specific tables in MySQL.

Resources

MySQL ODBC Driver


Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Hide Comments in Excel Completely - Even Indicators Will not Appear
Macro: Hide all comments in an Excel workbook. No indicators will be displayed and comments will ...
Import a Worksheet from One Workbook to Another in Excel
Tutorial: In Excel, you can quickly copy an entire worksheet from one workbook to another workbook....
Open a Word Document from Excel
Macro: This Microsoft Excel macro will open a Microsoft Word document from excel. With this m...
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
Macro: Delete a comment in Excel with this macro. You can permanently remove or delete a specific...
Tutorial Details
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course