vinukrishnan
Member
Hi,friends i want to establish a connection between SCADA(Intouch 10) and Microsoft Excel for report generation.please help me....
Scada and microsoft excel
- Thread starter vinukrishnan
- Start date
iknowsomeplc
Member
use DDE
aradhonline
Member
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
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
Member
OP
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
Member
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
1.http://lmgtfy.com/?q=wonderware+intouch+odbc
else /* To be precise */
2.http://www.presys.co.uk/Content.aspx?PageID=10
Similar Topics
I have an old plc in the system I have, moxa nport was used to communicate with scada, I want to replace the plc with cj2m cpu33 and eliminate...
Has anyone ever seen where you have a tag reading from the plc in scada. In this instance it's just a PEC, I set it up on one scada terminal and...
Hi guys,
I have experience with PLC to Excel etc...just starting on using intouch scada screens.
I have an Excel sheet that uses mainly...
Hello guys, I would need some help. I have installed the aveva plant scada and want to run a project. From the configurator, all are fine, as I...
Is it possible to connect a PC with running WinCC Advanced or Unified to a siemens PLC such as S7-1200 across different subnets? The computers can...