Import Historian Data into Excel Using the Sample UDL File

About this task

With the sample universal data link (.UDL) file, you can specify the connection information so that Excel can connect to the tables in the OLE DB provider and import data using the default server and the currently logged-in user.

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

Procedure

  1. Open an Excel spreadsheet.
  2. Select Data > Import External Data > Import Data.
    The Select Data Source window appears.
  3. Select the Historian.udl file in the Historian\Samples\Excel folder, and then select Open.
    The Select Table window appears.
  4. Select the table that you want to query, and then select OK.
    The Import Data window appears.
    Note: If you want to run a SQL command instead of the default table command setting, refer to Edit SQL Queries in Excel.
  5. Select OK.
    Historian data appears in the spreadsheet.