数据采集系统中数据批量录入的一种实现方法

【作者】 孙建华； 姜宏波；

【机构】 合肥工业大学；

【摘要】 本文详细论述了采用MSComm ActiveX控件和bcp命令实现数据批量录入的方法。首先,通过MSComm控件与下位单片机进行通讯,将下位机采集的数据接收上来,经处理后写入临时文件;然后,用bcp命令降临时文件中的数据录入数据库。该方法实现简单,执行速度快,适应范围广(可应用于ACCESS、SQLSERVER、ORACLE等数据库生成工具生成的数据库)。更多还原

【Abstract】 This paper demonstrates the way to implement bulk insert of data by using MSComm control and bcp utility. Firstly, data which is collected by SCM is sent up through the communication (implemented by MSComm control) between SCM and main computer ;secondly the data is written into tempoary file ;then data in the temporary file is bulk inserted into database through bcp utility. This method has character of simple-ness, fast executing and wide applicability (can be applied to database built by ACCESS, SQLSERVER and O-RACLE etc. ).更多还原