Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt
PDF (US Ltr) - 2.6Mb
PDF (A4) - 2.6Mb
EPUB - 2.3Mb
HTML Download (TGZ) - 2.2Mb
HTML Download (Zip) - 2.3Mb


MySQL and Windows  /  Installation

Chapter 5 Installation

MySQL for Excel is a 32-bit add-in for Microsoft Excel, which you can install with MySQL Installer for Windows. MySQL for Excel does not run on OS X or macOS.

MySQL for Excel can interact with MySQL Workbench to simplify the management of MySQL connections when both MySQL client tools are installed. MySQL Workbench is not required to perform database operations from MySQL for Excel.

MySQL for Excel Requirements

  • .NET Framework 4.0 (Client or Full Profile).

  • Microsoft Office Excel 2007 or later, for Microsoft Windows.

  • Visual Studio 2010 Tools for Office Runtime. MySQL Installer may install this for you.

    Note

    This requirement is different than Office Developer Tools for Visual Studio, which is not a substitute.

  • An available MySQL server connection.

MySQL for Excel Download and Install

There are two download options available for installing MySQL for Excel:

  • Standalone: Download and execute the MySQL for Excel standalone MSI file. With this option, you must ensure that all MySQL for Excel requirements are met before executing the MSI file.

  • MySQL Installer: Download and execute the MySQL Installer MSI file. This option is recommended because, in addition to managing all MySQL client applications for Windows, MySQL Installer evaluates the installation requirements on your computer for you.

    • When MySQL Installer is installed for the first time: Use the Developer, Client Only, or Full setup types to install MySQL for Excel together with other MySQL applications. Use the Custom setup type to install MySQL for Excel alone.

    • When MySQL Installer is already installed: Use the Add operation to install MySQL for Excel.

    For additional installation and usage instructions, see Section 1.3, “Installing MySQL on Microsoft Windows Using MySQL Installer”.

Open MySQL for Excel

MySQL for Excel is loaded and executed by selecting the Data menu tab in Excel, and then clicking the MySQL for Excel button from the ribbon. This button opens the MySQL for Excel task pane from which you can select options and operations. Initially, MySQL for Excel displays connection information, as shown in the following figure.

Figure 5.1 MySQL for Excel Button and Task Pane

MySQL for Excel button and task pane


User Comments
Sign Up Login You must be logged in to post a comment.