中文摘要：

WinCC是一款功能强大的HMI系统，它可以组态界面并可以对数据进行归档，但是对于一些复杂的数据处理如数据查询，计算和统计，就显得力不从心．文章利用VB编程工具建立了WinCC的归档数据库与Access数据库和EXCEL的连接，并生成了．exe文件，通过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 EXCEL based 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.