Accessing data in Microsoft Excel from the Data Connection Wizard (Windows only)

After you have configured your data source, you can use the driver to access your data with Microsoft Excel from the Data Connection Wizard. Using the driver with Excel provides improved performance when retrieving data, while leveraging the driver's relational-mapping tools.

To use the driver to access data with Excel from the Data Connection Wizard:

  1. Open your workbook in Excel.
  2. From the Data menu, select From Other Sources>From Data Connection Wizard.
  3. The Welcome to Data Connection Wizard dialog appears.

    Excel Data Connection Wizard

    Select ODBC DSN from the data source list; then, click Next.

  4. From the ODBC data sources list, select your data source. Click Next.
  5. The logon dialog appears pre-populated with the connection information you provided in your data source. If required, type your password. Click OK to proceed.
    Note: The logon dialog may reappear if Excel needs to access additional information from the data source. If this occurs, re-enter your password; then, click OK to proceed to the next step.
  6. The Select Database and Table window appears.

    Select Database and Table window

    • To access data from multiple tables, uncheck the Connect to a specific table box; then, click Next.
    • To access data from a specific table, select the table you want to import from the list; then, click Next.
  7. Enter the file name, description, and, optionally, the friendly name and search keywords for your Data Connection file in the corresponding fields. Click Finish.
    • If you chose to access data from multiple tables in Step 6, proceed to the next step.
    • If you chose to access data from a specific table in Step 6, skip to step 9.
  8. The Select Table window appears.

    Select Table window

    Select the tables that you want to import into your workbook; then, click OK.

  9. The Import Data window appears.

    Import Data window

    Select the desired view and insertion point for the data. Click OK.

You have successfully accessed your data in Excel using the Data Connection Wizard. For more information, refer to the Microsoft Excel product documentation at: https://support.office.com/.