Jump to main content
×
Have You Seen Historian Lately? Click here
Supercharge your GE solution! free trial events.
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
Open an Excel worksheet.
Select .
The Select Data Source window appears.
Select .
The Data Connection Wizard appears.
Select Other/Advanced from the list of data sources to which you can connect, and then select Next . The Data Link Properties window appears.
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.
Leave these fields empty to use the default server and the currently logged-in
user. Otherwise, do the following:
Enter the name of the Historian server in the Data
Source field.
Clear the Blank Password check box.
Enter a Windows username and password.
Select the Allow Saving Password check box if
applicable.
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.
Select the table that you want to query, and then select Next . The Save Data Connection File and Finish page appears in the wizard.
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 .
Select OK to import the column data from the selected table. Historian data populates the current spreadsheet.
Historian