Wincc 7.4 to sql stackoverflow

Sub Create_new_table ()
Dim conn, rst, SQL_Table, name

On Error Resume Next

Set conn = CreateObject("ADODB.Connection")
Set rst = CreateObject("ADODB.Recordset")
name =Year(Date) & "_" & Month(Date) & "_" & Day(Date)
'Open data source - Datenquelle öffnen
conn.Open "Provider=MSDASQL;DSN=Database" 'DSN= Name of the ODBC database - DSN= Name der ODBC-Datenbank

'Error routine - Fehlerroutine
If Err.Number <> 0 Then
    ShowSystemAlarm "Error #" & Err.Number & " " & Err.Description
    Err.Clear
    Set conn = Nothing
    Exit Sub
End If


' FORMING TABLE
SQL_Table = "CREATE TABLE Paster_TT43_" & name & "(" &_
        "Signal NVARCHAR(30) ," &_
        "Date NVARCHAR(30) ," &_
        "Time NVARCHAR(30) ," &_
        "Value NVARCHAR(30)  )"
Set rst = conn.Execute(SQL_Table)

' There are more tables to create there is one for example
'Error routine - Fehlerroutine 
If Err.Number <> 0 Then
    ShowSystemAlarm "Error #" & Err.Number & " " & Err.Description
    Err.Clear
    'Close data source - Datenquelle schließen
    conn.close
    Set conn = Nothing
    Set rst = Nothing
    Exit Sub
End If

'Close data source - Datenquelle schließen
conn.close

Set rst = Nothing
Set conn = Nothing

End Sub

Source: stackoverflow.com

Similar codes

8 votes141 views1 answer
Script to add datafile to tablespace
SQL
0 vote142 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote143 views1 answer
Sql convert unix time to date
SQL
0 vote181 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote148 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote138 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote132 views1 answer
Postgres - Login and connect as default user
SQL
0 vote142 views1 answer
Select nth row in mysql
SQL
-1 vote144 views1 answer
Adding a new table psql
SQL
0 vote125 views1 answer
Is numeric in sql
SQL