Connecting to MySQL
The SaveToDB add-in allows connecting to MySQL tables, views, and stored procedures.
The SaveToDB add-in supports the following data providers:
- MySQL ODBC Driver
- MySQL Data Provider for .NET
The add-in ships the .NET data provider. So, you can use it from the box.
You can download and install MySQL ODBC drivers at https://dev.mysql.com/downloads/connector/odbc/.
Microsoft Excel supports MySQL ODBC drivers and does not support .NET data providers.
You can connect to MariaDB databases using MySQL providers and drivers.
Here is a sample of the Database Connection Wizard page where you can select the data provider:
Connecting to MySQL Databases
Use the following server name format for MySQL:
<Server name or IP-address>[;port=<Port>]
Here is a sample of the connection to the s02 database on the localhost:
Below is a sample of the connection to the s02 database on localhost port 3306: