Choose Your Data Source

  1. Start Excel. Excel automatically opens a new spreadsheet.
  2. Perform the following steps if your are using Excel 2000:
    1. Click Tools > Add-Ins. If your Microsoft Office menus are set to Show recently used commands first, you may need to click the expansion arrows at the bottom of the Tools menu to see the Add-Ins option.
    2. In the Add-Ins dialog box, select the MS Query Add-In checkbox and click OK. If this add-in does not appear on your list, reinstall Excel, being sure to select MS Query from the list of functions to install.
    3. In the Add-Ins dialog box, select the MS Query Add-In checkbox and click OK. If this add-in does not appear on your list, reinstall Excel, being sure to select MS Query from the list of functions to install.
  3. Perform the following action based on your Excel version:
    Excel Version Action
    2000 or 2003 Click Data > Import External Data or Data > Get External Data and then click New Database Query from the submenu.
    2007 Click Data > From Other Sources > From Microsoft Query.

    This starts Microsoft Query and opens the Choose Data Source dialog box.

    If you want to use Microsoft Query Query Wizard to create your SQL query, leave the Use Query Wizard check box checked. For instructions on using the Query Wizard, see Microsoft Query's online documentation.

    For this exercise, uncheck the Query Wizard check box.

  4. In the Choose Data Source dialog box, click the data source name (DSN) that corresponds to the data source you want to access and click OK.

    See Setting Up DSNs on the Client for instructions on creating DSNs.

  5. If you or an administrator established database security methods during AcuXDBC setup, the AcuXDBC login dialog box appears; type a valid User ID and Password, and click OK.
    Tip: You can display just the tables of a given user by selecting from the owner drop-down list. For example, you could display only the tables that belong to PUBLIC by choosing PUBLIC from the drop-down list.
    The Add Tables dialog box appears.
    Note: If no security methods have been established, a User ID and Password are not required and the Login dialog box will not appear.
Parent topic: Accessing Data From Excel