ARCHIVED: Use MySQL for Excel to access your MySQL database on the Research Database Complex at IU

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

Following are instructions for downloading, installing, and configuring MySQL for Excel version 1.3.6.

On this page:


Overview

Oracle's MySQL for Excel is an add-in for Windows-based Excel. It provides a wizard-like interface for browsing MySQL schemas, tables, views, and procedures, and performing data operations against them in Excel. It also lets you import MySQL data into Excel, create new MySQL tables from selected Excel data, append Excel data to existing MySQL tables, and edit MySQL table data directly from Excel.

Note:
  • MySQL for Excel can return all rows, or a specified range of rows, from a single table only. It cannot import data stored in two different tables, perform table joins, or filter data. Consequently, for example, you can use MySQL for Excel to import rows 1 through 5 in a single table, but you cannot use it to import only those rows that meet certain criteria, such as rows in an employee table with an "employee status" of inactive. If you need to run MySQL queries that involve data filtering or retrieving data from more than one table, see Use MS Query to connect to your MySQL database at IU RDC.
  • Currently, MySQL for Excel is not available for Excel for Mac.

Download and install MySQL for Excel

To install the MySQL for Excel add-in, you must be logged into your workstation as an administrator.

The MySQL for Excel installer will check your system to make sure it meets the following requirements; the installer will notify you if further action is needed before starting with the installation:

  • .NET Framework 4.0 (client or full profile)
  • Excel 2007 or later
  • Visual Studio 2010 Tools for Office Runtime (This is required to run Office-based tools built with Visual Studio; the MySQL for Excel installer may install this for you. Office Developer Tools for Visual Studio is not a substitute for this requirement.)
  • An available MySQL Server connection.

To get the installer, download the standalone MSI file.

To run the installer:

  1. On your workstation, open the folder containing the installer file (mysql-for-excel-1.3.6.msi), and then right-click the file and select Install.
  2. If you see a security warning asking whether you want to run this file, click Run.
  3. When the MySQL for Excel 1.3.6 Setup wizard launches, click Next.
  4. To accept the default destination folder, click Next. Alternatively, to select a custom location, click Change, browse to the desired folder (or create a new one), click the desired folder, click OK, and then click Next.
  5. When prompted, click Install to begin the installation.
  6. If you see a security warning asking whether you want the program to install the software on your computer, click Yes.
  7. If your system prompts you to log in as an administrator, enter the username and password for a local administrator account to proceed.
  8. When the installation is complete, click Finish to exit the setup wizard.

To access the MySQL for Excel add-in, launch Microsoft Excel, and then, on the Data tab (to the right), click MySQL for Excel.

Connect to your MySQL database

Note:

To configure MySQL for Excel to connect to your MySQL database on the RDC:

  1. In Excel, on the Data tab, click MySQL for Excel to launch the add-in.
  2. In the "MySQL for Excel" panel (near the bottom), click New Connection.
  3. In the "MySQL Instance Connection" screen:
    • For "Connection Name", enter a name for the connection (for example, RDC-MySQL).
    • For "Connection Method", make sure that Standard (TCP/IP) is selected.
    • For "Hostname", enter the hostname of the RDC server: sasrdsmp01.uits.iu.edu
    • For "Port", enter the TCP/IP port number: 3006
    • For "Username" and "Password", enter the credentials for a MySQL account that has permissions to access your database.
    • Optionally, for "Default Schema", enter a schema name.
    • To confirm the connection, click Test Connection. If the connection is valid, click OK.
  4. The newly created connection should appear in the "MySQL for Excel" panel; double-click its name to open a connection to your database.

Once your connection is configured in the MySQL for Excel add-in, you can return to it later; just open Excel, go to the Data tab, click MySQL for Excel, and then, double-click the name of your connection.

Get help

For help using MySQL for Excel, see the MySQL for Excel Guide.

If you need help connecting to your MySQL database on the RDC, email the RDC Administration team.

For information about RDC database accounts, see the Databases section of About the Research Database Complex (RDC) at Indiana University.

Note:
UITS does not support MySQL for Excel beyond providing installation instructions and helping you connect to your database.

This is document amse in the Knowledge Base.
Last modified on 2021-05-05 17:14:42.