About this document

Citect ODBC to Excel SQL Issues by BanditsRTGSJSKAL is a document available to read on EtoBox.

The user is trying to connect Citect SCADA software to Excel using ODBC and SQL statements to transfer data in real-time from Citect tags to an Excel spreadsheet. However, they are receiving errors when trying to execute the SQL statements. Based on suggestions from forum responses, building the SQL insert string with tag values concatenated worked. Using MSQuery to test SQL statements on spreadsheets first also helped debug the syntax. While Citect

Author

BanditsRTGSJSKAL

Language

EN