Import Historian Data Into Excel Manually

About this task

This topic describes how to import Historian data into Excel by providing the connection details manually. You can also import the data by creating a UDL file or by using the sample UDL file.

Procedure

  1. Open an Excel worksheet.
  2. Select Data > Import External Data > Import Data.
    The Select Data Source window appears.
  3. Select My DataSources > +Connect to New Data Source.odc > Open.
    The Data Connection Wizard appears.
  4. Select Other/Advanced from the list of data sources to which you can connect, and then select Next.
    The Data Link Properties window appears.
  5. Select Historian OLE DB Provider from the OLE DB Provider list, and then select Next.
    The Connection section appears in the Data Link Properties window.
  6. Leave these fields empty to use the default server and the 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 if applicable.
  7. 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.
  8. Select the table that you want to query, and then select Next.
    The Save Data Connection File and Finish page appears in the wizard.
  9. Accept the default settings, and select Finish.
    The Import Data window appears.
    Note: If you want to run a specific SQL command instead of the default table command setting, refer to Edit SQL Queries in Excel.
  10. Select OK to import the column data from the selected table.
    Historian data populates the current spreadsheet.