Microsoft Excel

With Excel, you can import a snapshot of Historian data at a single point in time. You can choose Historian as a data source in Excel. You can specify the connection settings manually or using a UDL file.

After you import the data, you can create and edit SQL queries in Excel.

When to Use Excel Instead of the Historian Excel Add-In

Use the Excel Add-In when you want to get data into Microsoft Office 2003, 2007 or 2010 (32-bit/64-bit). Use the Historian OLE DB provider with Excel, instead of the Excel Add-In, when you want to do any of the following:

• Perform advanced filtering, sorting, and joining of data.
• Obtain detailed information from the ihTrend table.
• Run calculations using the SQL aggregate functions.
• Perform advanced summaries.

Table 1. Microsoft Excel Samples

File Name	Description
ihOLEDB_ LASTHOUR.XLS	One-sheet report that uses auto-refresh to display the last hour of data using relative shortcuts.
ihTags.odc	Data source file that retrieves the ihTags table from the default server.
iHistorian.udl	Sample universal data link (.UDL) file that connects to the default Historian server with the currently logged-in user.

These sample are found in the following folder: Historian\Samples\Excel