摘要
本文是在开发数据库管理系统的实践中,为解决把大量以Excel表形式保存的学生历史考试成绩自动录入数据库的问题,提出了一种利用PowerBuilder特有的数据窗口、OLE技术以及对文件进行操作的函数等把Excel表导入SQL Server数据库的一种高效率的实现方法,并在所研发的系统中运行成功。
In order to switch massive data saved as excel table into database automatically, proposed one kind of high-efficiency method for switching data saved as excel table into database by using the PowerBuilder's unique data window, the OLE technology as well as function on the operation to the document, and it was run successfully in practice.
作者
康亚
邵康
吴满意
KANG Ya,SHAO Kang,WU Man-yi(Institute of Economy and Management, Anhui University of Science & Technology,Huainan 232001,China)
出处
《电脑知识与技术》
2008年第6期1179-1181,共3页
Computer Knowledge and Technology