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 Into Excel by Using a .UDL File

Procedure

From the Data menu, select Import External Data and then Import Data.
Select the .UDL file that you just created, and then select Open.
The Select Table window appears.
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.
Select OK to import the column data from the selected table.
Historian data populates the current spreadsheet.