Use MS Query to connect to your MySQL database on the RDC at IU

In Excel, Microsoft Query (MS Query) lets you connect to and query external data sources, import data into your worksheet, and refresh worksheet data automatically whenever those external data sources are updated with new information. For more about using MS Query, see Use Microsoft Query to retrieve external data in the Microsoft Office Support documentation.

Note:

To use MS Query to connect to your MySQL database on the Research Database Complex (RDC) at Indiana University, you first need to create a MySQL ODBC source on your computer; for instructions, see Set up an ODBC source in Windows to access your MySQL database on the Research Database Complex at IU. Also, before users, including the root user (i.e., you), can connect to your MySQL server instance, you must create MySQL accounts for them and grant them appropriate access privileges; for instructions, see Create user accounts for your MySQL database on the RDC at IU.

Once those criteria are met, to connect to your MySQL database via MS Query:

  1. In an Excel worksheet, on the Data tab, select Get Data > From Other Sources > From Microsoft Query.
  2. In the "Choose Data Source" window, on the Databases tab, find the ODBC source you created, and then double-click its name.

If you need help using MS Query to connect to your MySQL database on the RDC, contact the UITS High Performance Systems (HPS) team; UITS does not support MS Query beyond helping you connect to your MySQL database. For more about RDC database accounts, see the Databases section of The Research Database Complex (RDC) at Indiana University .

This is document amte in the Knowledge Base.
Last modified on 2018-01-31 15:08:05.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.