Data Migration from Visual Basic Interfaces to Excel Tables Prevent Conflict Using Proposed Models

Abstract

In relational and complex spreadsheets, relational and non-relational database models, high-speed data migration with scalable structure using visual Basic Excel programming language implementations with proposed migration model. One of the primary purposes behind making a point of interaction through the Visual Basic Application (VBA) is that most PC clients with logical preparation will currently know about Succeed and its significant capabilities (like arranging furthermore, plotting datasets). Even though Excel itself is in many cases utilized as an information storehouse by clients. The time factor, reliability, and credibility of migrating this data from one table to another through programming interfaces were measured using the link codes between the tables. In this paper, the migration and migration of homogeneous and heterogeneous data are investigated by using two types of different migration models of data to measure and match these data and the extent of their integration after migration. Specifies the target data for migration from the input tables in the Excel program to the target tables in larger databases. Furthermore, the two models (A, B) middleware provide an architecture that can be extended to support Relational database management systems (RDBMS) and other graphing databases. Experiments were performed using excel tables, both of which are related as source information bases, and as the data set for the source and target datasets, the migration time between these tables for the two models was calculated While retaining the same characteristics.