用VB实现数据库中大容量数据的导入导出  

Import and Export of Magnitude Data in Database by VB

作　　者：孙汪泉[1] 刘志勤[1] 江为强[1] 

机构地区：[1]西南科技大学计算机科学学院,四川绵阳621002

出　　处：《兵工自动化》2003年第1期55-57,共3页Ordnance Industry Automation

摘　　要：数据库中大容量数据存储管理速度慢,可用VB实现数据快速导入导出。其导入模块中由2个文本框分别连结数据表中的文件名字段和文件路径,导入按钮将当前数据作为一条记录添加到数据库中。导出模块由列表浏览器列出数据表中所有记录,导出按钮将选择的记录导出到指定路径。由于系统内存使用量达一定比例时导入导出效率最高,故每次读取数据块大小可根据物理内存及内存使用百分比设定。由此导出其数学模型,并采用VB 6.0在后台数据库MS SQL Server 2000中设计了该方法的实现程序。The speed of storing and managing magnitude data is slow, however, the realization of importing and exporting magnitude data at higher speed by Visual Basic is possible. There have two textboxes each correlated filename fields and file path fields of the table in the database and an import button for appending data in textbox to database as a record in the interface of import module. And in the interface of export module, all the records if they meet the condition will be listed in listview box, and press the export button, the selected records would be exported to the special path. Based on the result of experiment, the efficiency of importing and exporting data is highest when EMS memory is used about the limit. So the size of data reading each time can be prescribed based on the physical memory and the percentage of it. And then deduced the mathematical module and programming it in MS SQL Server 2000 by VB 6.0.

关 键 词：VB 数据库 数据导入 数据导出 设计 

分 类 号：TP311.131[自动化与计算机技术—计算机软件与理论]