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

print



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