Getting S7 DB data to MS Access or SQL

B

Thread Starter

Bhavana

Hello,

Please suggest to me how to get S7 DB data to MS Access or SQL for generating reports.

I am using SoftPLC, WinLC and OPC server and now
I am getting required data in S7 DBs.

But my requirement is to show these data as a report.

Thanks and Regards,
Bhavana
 
If you are using WinLC Basis, you have three options, (1) S7 Data Control, this is a component available with WinLC Computing. It is not installed with WinLC as of ver 4, but it is on the installation CD and may be installed. You can reference the control in Visual Basic and Excel. I have not tried it with Access. (2) There is a component called Simatic Data Control for Excel that is very easy to use and setup. You must install Simatic Computing and Excel before you install Simatic Data Control for Excel. (3) Since you have OPC Server available, it would be easiest to use the Simatic Net OPC Client Control available with your Simatic Net Installation. This control may be used with VB.net Visual Basic and other Microsoft titles. The biggest concern you will have is how much data is to be passed and how fast. You can find example code and help on the Siemens Website. Good Luck!
 
Top