AnsweredAssumed Answered

Processbook ODBC import-export

Question asked by PiPong on Jan 26, 2016
Latest reply on Mar 25, 2016 by jsoulis


I have a table in Excel that I am using in Processbook via VBA to access it as a ODBC connection. From that table I get values into a trend with other Pi tags.


I have set a textbox where the user after analyzing the data make some comments that I want to register in the same excel spreadsheet. What i am trying to do is by pressing a button to insert this into excel but would like to do it without opening the application.


is there a way to use the ODBC connection and via INSERT INTO command add a value into excel? Or should I try other options where I store the data rather than excel?


thanks for your input.