Now click the Test button to establish a test connection to your data source.In the appeared dialog, specify the required connection settings and click OK.Find the DEVART_MYSQL section and click the Configure button: Run the iODBC utility of the required bitness.You can use it to test a connection with MYSQL server. To activate the driver, perform the steps described in the Product Activation article.Īfter the driver is installed, DSN with the name DEVART_MYSQL is created. If you have the activation key file, click the Load Activation Key button and browse to it.Copy the activation key from the registration email or your Customer Portal account and paste it into the Activation Key edit box. If you have an activation key, select the Activation Key option. If you have no activation key, you can select Trial and use the driver for evaluation purposes. In the License Information dialog box, you should select the license type and activate the product. Run the downloaded file and follow the instructions in the wizard.Īfter reading the license agreement, click Agree to proceed with the installation. Download the PKG file from the Devart website.In case when using other ODBC driver managers, ODBC Driver for MySQL will be installed, but it will require manual modification of configuration files of these managers. Microsoft Excel features calculations, graphing tools, pivot tables, and a macro programming language that allows users to work with data in many of the ways that suit their needs, whether on a Windows machine or a Macintosh machine. ODBC Driver for MySQL is compatible with iODBC driver manager. Create a Data Source Name in iODBC with the CData ODBC Driver for Access and work with Access data in Microsoft Excel on Mac OS X. ODBC driver manager is not distributed along with our driver and must be installed separately. ODBC Driver for MySQL works under control of an ODBC driver manager.

Odbc for mac excel