Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.
Importing Data 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 Historian OLE DB Provider and import data using the default server and the currently logged-in user.
Procedure
Open Microsoft Excel.
From the Data menu, select Import External Data, and then select Import Data.
The Select Data Source dialog box appears.
Select the Historian.udl file in the Historian\Samples\Excel folder, and then click Open.
The Select Table dialog box appears.
Click the table that you want to query, and then click OK.
The Import Data dialog box appears.
Note: If you want to run a SQL command instead of the default table command setting, refer to Edit SQL Queries in Excel.
Click OK to import the column data from the selected table.