Scada and microsoft excel

[vinukrishnan]

Hi,friends i want to establish a connection between SCADA(Intouch 10) and Microsoft Excel for report generation.please help me....

 

[iknowsomeplc]

use DDE

 

[aradhonline]

use odbc . Create a Dsn and flush your data to it .some simple
SQL codes may help you. Lot of sample codes available in in touch
Use a pivot table in excel to suck the data from the odbc .

Make sure your code for the SQL trigger is perfect .otherwise
You will screw around with microsof products as bill gates people
Are not willing to accept even piped data from outside . Hi hi

 

[vinukrishnan]

i tried but since i have only a little knowledge in odbc,sql i am unable to achieve a connection between scada and excel.......

 

[aradhonline]

then /* Global method */

1.http://lmgtfy.com/?q=wonderware+intouch+odbc

else /* To be precise */

2.http://www.presys.co.uk/Content.aspx?PageID=10