利用VB实现WinCC归档数据处理

摘要

While WinCC is able to configure interface and archive data as a powerful HMI system, it is inadequate for complex data processing such as data query, computing and statistics. In this paper, the WinCC archiving database is connected with Access database and EXcellbased on VB, then an exe file is generated and can be directly called by WinCC, in which case experimenters can select data storage method and path according to their preferences and accomplish conditional query and complex processing for data.%WinCC是一款功能强大的HMI系统，它可以组态界面并可以对数据进行归档，但是对于一些复杂的数据处理如数据查询，计算和统计，就显得力不从心.文章利用 VB 编程工具建立了 WinCC 的归档数据库与 Access数据库和EXCEL的连接，并生成了.exe文件，通过WinCC的直接调用，实验人员可以根据自己的喜好去选择数据存储方法和路径，实现数据的有条件查询和复杂处理.