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.

Export Query Results to Microsoft Excel

The Historian OLE DB Interactive SQL application allows you to export the results of a query directly into Microsoft Excel, as shown in the following figure.

Figure: Sample Export of Query Results Into Microsoft Excel

After you export the results, you must format the date and time column in Microsoft Excel so that it displays correctly. See Formatting Dates and Times in Excel for instructions on how to format the date column.