GLIS6下用EXCEL数据实现读者信息批量快速导入的方法

Method of Using Excel Data to Realize Reader’s Information Mass and Fast Import to SQL Database in GLIS6

为新生读者办理借阅证是高校图书馆流通管理的一个基础环节,如何短时间内为学生办好借阅证,是摆在各家图书馆面前一项急需解决的问题。通过在实践中摸索,找到了一种利用Excel数据,实现读者信息批量快速导入SQL数据库的方法,从而极大地提高了办理借阅证的效率。

Transactions the library card for the freshmen is a basic part in the circulation management of university library,how to finish this task in short time for the student is an urgent question need to be solution appear in front of per library,the author through practice in reality,found one kind method through using the Excel data which realizes the reader’ s information mass and fast import to the SQL database,thus enhanced enormously the efficiency of transactions the library card.Introduced through this article,the author hoped has the enlightenment to the persons of the same trade.