Abstract: A versatile data import method,based on instruction system,has been put forward to solve the problem of lack of versatility in methods for the Excel data into the database at present.We designed a set of instruction system for Excel data extraction,which provides different Excel table with a configurable command file that could be parsed by the command interpreter so as to finish Excel data extraction and data import into database automatically.Practical application shows that the instruction system has good versatility.