Importing Historian Table Data Into Excel

Procedure

  1. From the Data menu, select Import External Data and then Import Data.
    The Select Data Source dialog box appears.
  2. Select +Connect to New Data Source.odc from the My DataSources folder (the default folder) and click Open.
    The Data Connection Wizard appears.
  3. Select Other/Advanced from the list of data sources to which you can connect, and then click Next.
    The Data Link Properties dialog box appears.
  4. Select Historian OLE DB Provider from the OLE DB Providers list, and then click Next.
    The Connection tab appears in the Data Link Properties dialog box.
  5. Leave these fields empty to use the default server and currently logged-in user. Otherwise, do the following:
    1. Enter the name of the Historian server in the Data Source field.
    2. Clear the Blank Password check box.
    3. Enter a Windows username and password.
    4. Select the Allow Saving Password check box.
      Note: You only need to select the Allow Saving Password check box when the password is not blank.
  6. Click Test Connection to confirm that the data source, username, and password provide a successful connection, and then click OK.
    The Select Database and Table screen appears in the wizard.
  7. Click the table that you want to query, and then click Next.
    The Save Data Connection File and Finish screen appears in the wizard.
  8. Accept the default settings and click Finish.
    The Import Data dialog box opens.
    Note: If you want to run a specific SQL command instead of the default table command setting, refer to Edit SQL Queries in Excel.
  9. Click OK to import the column data from the selected table.
    Historian data populates the current spreadsheet.