Connecting to MySQL

The SaveToDB add-in enables connections to MySQL tables, views, and stored procedures.

Supported data providers for the SaveToDB add-in include:

The add-in includes the .NET data provider, so you can use it right out of the box.

To download and install MySQL ODBC drivers, visit https://dev.mysql.com/downloads/connector/odbc/.

Note that Microsoft Excel supports MySQL ODBC drivers but does not support .NET data providers.

You can also connect to MariaDB databases using MySQL providers and drivers.

Below is a sample of the Database Connection Wizard page, where you can select the data provider:

Connecting Excel to MySQL Database - Selecting Provider

Connecting to MySQL Databases

Use the following format for the MySQL server name:

<Server name or IP-address>[;port=<Port>]

Here’s an example of connecting to the s02 database on localhost:

Connecting Excel to MySQL Database

Below is an example of connecting to the s02 database on localhost at port 3306:

Connecting Excel to MySQL Database