WINCC中读取ACCESS

    技术2022-05-19  21

    经测试该代码在WinCC和.vbs文件中均可用可用

    Dim objConn,objRs,strSqlSet objConn = CreateObject("ADODB.Connection")objConn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=d:/student.mdb"objConn.openSet objRs = CreateObject("ADODB.RecordSet")strSql = "Select count(*) from 学生情况"objRs.open strSql,objConn,1,2msgbox "学生情况表中共有" & objRs(0) & "条记录",8,"记录统计:"objRs.closeSet objRs = nothingobjConn.closeSet objConn = nothing 


    最新回复(0)