Using Vba To Achieve The Original System Of The Enterprise Data Integration And Its Application

We can find data that happened 10 years ago in database. But there are some parts of the data where even now people cannot find in the network from the next door. The only way that they can transmission their infromation is from one hand to the others. This is the most old enterprises in the isolated islands of information issues. How to solve these problems?Two main techniques have been used for solving the problem of old information system, which we may respectively the tough and the gentle. The former method simply consists of setting a new system to work and beating the enterprise adapt it until all of the people does what is expected of it. Apart from time considerations this is a dangerous method , for it produces a resentful all people who at a later stage may well turn enterprise-killer. The gentle method requires more patience in the early stages, but produces a conservatived, good-tempered Compromise system.Enterprise's branchs can unrestricted exchange data is a trend. In this trend, integrating resources has become a corporate figures. Data exchange is a very important internal communication tool. In the enterprise's data could not be exchanged for two main reasons. One, because of the influx of non-compatible software exists, it causes the software is not directly exchange data. Two, the enterprises is not a very tight structure, leading enterprises are unable to use the common C/S and B/S data exchange model.Focusing on. these two companies and the actual situation, corporate data format limited the planning and transmission planning is an inevitable way. The first is against standardized format, the company used basic Excel Document such common data exchange model, Therefore, using Excel for data transmission intermediates has good interoperability and compatibility. Second generation and processing statements for the Excel can use the Office of VBA and SQL both Excel tools to accomplish -database data between computing and transmission. Again data exchange model can be used in this Part C/S system, branch headquarters and the B/S system and projects of the Department of E-mail system this more flexible approach to data exchange. The last is how to control the network data transmission.