Data entry is an onerous work in groundwater dynamic monitoring database. Traditional manual method has the characteristics of low efficiency and some mistakes. In this paper, a new automatic entry method by using VBA program has been introduced. It will greatly improve the efficiency and reduce errors.