Importing Historian Table Data Into Excel

Procedure

  1. From the Data menu, select Import External Data and then Import Data.
    The Select Data Source window appears.
  2. Select +Connect to New Data Source.odc from the My DataSources folder (the default folder) and select Open.
    The Data Connection Wizard appears.
  3. Select Other/Advanced from the list of data sources to which you can connect, and then select Next.
    The Data Link Properties window appears.
  4. Select Historian OLE DB Provider from the OLE DB Provider's list, and then select Next.
    The Connection section appears in the Data Link Properties window.
  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. Select Test Connection to confirm that the data source, username, and password provide a successful connection, and then select OK.
    The Select Database and Table page appears in the wizard.
  7. Select the table that you want to query, and then select Next.
    The Save Data Connection File and Finish page appears in the wizard.
  8. Accept the default settings and select Finish.
    The Import Data window 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. Select OK to import the column data from the selected table.
    Historian data populates the current spreadsheet.