基于VB、Excel和Access的蠕变实验机测控软件系统  

Measurement and control system of creep testers under the Frame of VB、Excel and Access

作　　者：安子良[1] 轩福贞[1] 涂善东[1] 

机构地区：[1]华东理工大学机械与动力工程学院,上海200237

出　　处：《中国测试技术》2007年第3期84-87,共4页CHINA MEASUREMENT & TESTING TECHNOLOGY

基　　金：国家自然科学基金(50475068);国家高新技术研究发展专项经费资助(2006AA04Z413)

摘　　要：数据采集和控制软件系统采用串口通协议,实现了对4台蠕变实验机多点数据采集和数据的自动记录。遵循温度控制器的RS485通讯协议,软件系统可以自动调控蠕变高温炉的温度。通过OLE技术和人工代码,VB与Access、Excel无缝连接,将试验数据保存到Access数据库中。运行结果表明系统的软、硬件工作稳定,可靠性高,完全实现了蠕变实验机的温度自动控制和试验数据的自动记录。Serial port communication protocol was introduced into the software system of data acquisition and control, multipoint data acquisition and data self-record of 4 creep testers were implemented. According to the RS485 communication protocol of the temperature controller, software system could autocontrol the temperature of the creep furnace. By means of the techniques of OLE and artificial code, the seamless integration among VB, Access and Excel were realized and the experimental results were saved into Access database. Operating results indicated that the hardware and software of the system are high reliability and stability, temperature auto-control and testing data self-record of the creep tester are completely achieved.

关 键 词：软件自动化 VB ACCESS EXCEL RS485通讯协议 多点数据采集 

分 类 号：TP273[自动化与计算机技术—检测技术与自动化装置]