Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

How do I insert data in a SQL table, that are not normalized, from the PLC?

218 views
Skip to first unread message

PLCSQL Link technical forum

unread,
Jul 15, 2016, 8:21:01 AM7/15/16
to PLCSQL Link technical forum
Some customers have requested to insert data from the PLC in an existing table, that doesn't comply to the default structure in the PLCSQL Link database.

We have created a simple Excel sheet, where you define which parameters should be written in which column in your own SQL table.

The output on the second sheet in the Excel file can be executed on the SQL Server, and will create a stored procedure for you to call from the PLC.
SQL SaveConventionalgenerator_V001.xlsx
Message has been deleted
Message has been deleted
Message has been deleted

f...@plcsql.com

unread,
Mar 25, 2019, 3:37:25 AM3/25/19
to PLCSQL Link technical forum


New Updated version.
SQL SaveConventionalgenerator_V003-dhl.xlsx
SQL SaveConventionalgenerator_V003-dhl.xlsx

f...@plcsql.com

unread,
Mar 25, 2019, 3:37:25 AM3/25/19
to PLCSQL Link technical forum

This is the same file except for MYSQL

SQL SaveConventionalgeneratorMySQL_V003.xlsx
Reply all
Reply to author
Forward
0 new messages