How to configure an ODBC database connection using a spreadsheet table for PI Output Enhancer


1) Open the odbcad32.exe located on C:\Windows\System32
2) Select Add
3) Select Microsoft Excel DriverĀ 
4) Click finish after selecting the driver
5) Enter the Data Source Name (DNS name set on the PIOE script SQL action)
5) Select the spreadsheet table
6) Select OK
7) Select OK

User-added imageUser-added image

UPDATED: August 07, 2017

Contact Us