VBA-Templates

Excel - MySQL ODBC Connection

ODBC Driver with ADODB Library

The driver user in this example is :

MySQL ODBC 5.3 ANSI Driver

You can ensure that the code content the proper ODBC Driver in ODBC Data Sources.

Download MySQL ODBC Driver

ConnectDB

To use the ODBC Connection :

ConnectDB Server, Database, user, Password

Example :

ConnectDB "192.168.1.153", "00_colo_production", "colouser", "colouser"

Print Pdf

Excel - Table Admin