Form Excel Data import (second lecture)

in the first talk we talked about the development of the import form. Prior to import, only suitable for small batches of data import, if you encounter a lot of data, the efficiency is very low. For example, the Delta Office system inside the hospital basic information, which contains a lot of hospitals, the hospital has a lot of departments below, if a hospital's guide department, the efficiency is very low. In this case, we can add the hospital name field to the department table, and then use the main table ID of the Department table to match the hospital table.

As follows:


The code for the import form is as follows:


The hospital name of the department table automatically matches the hospital name of the hospital table:

The original address; http://bbs.delit.cn/thread-228-1-1.html

Reprint please indicate the source;

Author: metric Technology www. Delit. cn

Form Excel Data import (second lecture)