Browse FAQs

How to write to ClearSCADA DataTable from Excel using VBScript and ODBC

Published date: 23 October 2018

DISCLAIMER

The example below is intended to demonstrate one or more features or methods and is presented as a configuration example only. Schneider Electric assumes no liability for the use or application of this example or any portion thereof.


Sometimes it is helpful to be able to write to a ClearSCADA DataTable from an external tool.
As an example, the following code, written in VBScript inside an Excel spreadsheet, will add a row in a DataTable called "Populate", which contains two fields, one string and one long value, as long as the DSN and credentials are correct:

Sub test()

Set ado = CreateObject("ADODB.Connection")
ado.Open "DSN=ClearSCADA", "Eng", "password"
If ado.State = 1 Then
    MsgBox "Connected"
End If

queryText = "insert into Populate (Comment, Num) values ('AnyStringAny', 100)"
ado.Execute queryText
ado.Close

Set ado = Nothing

MsgBox "Done"

End Sub

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.