將wincc中數(shù)據(jù)寫入access數(shù)據(jù)庫中

1、建立access表if￡ice...^sniplellSNia；-osa￡tOffict...i]E8KBif￡ice...^sniplellSNia；-osa￡tOffict...i]E8KBtosoftOfficeAccess￡設(shè)計(jì)如￡設(shè)計(jì)如□新建?il一旦便用沒計(jì)器創(chuàng)建表3使用向?qū)?chuàng)理表主逋過輸入數(shù)據(jù)包1建表新建新建r■TINCC_DAIA:表字段名稱數(shù)據(jù)類型1自動編號IagValue文本T：20口m文本rIagViLuet文本rt2、ODBC鏈接在控制面板中選擇管理工具，在管理工具中選擇數(shù)據(jù)源（ODBC）淙連接池關(guān)于選擇添加名稱DriverdaMierozuttp：n_aarquivumtexto（：+.選擇accessDriverdeMici-csottAccess（：*.mdt.JDriverdoMicrozottJB&wtdl?￡]定義數(shù)據(jù)源名稱，選擇D盤剛才建立的access文件。3、wincc全局腳本+[T]「-EditorVTS-Editor-1恩赫始標(biāo)徒模塊g項(xiàng)目模塊…?VTS-Editor□=□-X—L-r^選擇VBS，進(jìn)入后新建動作信息期性周期設(shè)定觸發(fā)器觸發(fā)時間。4、VBS腳本DimobjConnectionDimstrConnectionStringDimIngValueDimlngValueaDimlngValuebDimstrSQLDimobjCommandDimriqiriqi=NowstrConnectionString=Provider=MSDASQL;DSN=SampleDSN;UID=;PWD=;lngValue=HMIRuntime.Tags("yali").ReadlngValuea=HMIRuntime.Tags("wendu").ReadlngValueb=riqistrSQL="INSERTINTOWINCC_DATA(TagValue,TagValuea,TagValueb)VALUES('"&lngValue&"','"&lngValuea&"','"&lngValueb&"');"SetobjConnection=CreateObject("ADODB.Connection")objConnection.ConnectionString=strConnectionStringobjConnection.OpenSetobjCommand=CreateObject("ADODB.Command")WithobjCommand.ActiveConnection=objConnection.CommandText=strSQL

EndWithobjCommand.ExecuteSetobjCommand=NothingobjConnection.CloseSetobjConnection=Nothing注：yali,wendu為變量標(biāo)簽名稱。SampleDSN為數(shù)據(jù)源名稱。TagValue,TagValuea,TagValueb為access表格中對應(yīng)列名稱。WINCC_DATA為access表格名稱。5、wincc試驗(yàn)123.000456.0000.000用輸入輸出域?qū)懭胂鄳?yīng)變量數(shù)值B￥INCC_DATA:表扇號T扇號TagValnieTagVialueli7521234562013-12-1111:35:037531234562013-12-1111:35:047541234562013-12-11ll;35;057551234562013-12-11IL;35;0675&1234562013-12-1111:35:0775T1234562013-12-1111:35:087581234562013-12-1111:35:097591234562013-12-1111:35:107601234562013-12-1111:35:117611234562013-12-1111:35:127BZ1234562013-12-1111:35:137B31234562013-12-1111:35:147B41234562013-12-1111:35:157E51234562013-12-1111:35:167EB1234562013-