Arguably the best way to use 4TOPS Import and Validate is to create a separate Import Database. The Import Database has linked tables both for the Source database and the Destination database.
Source database: the database containing the data you want to import
Destination database: the database you want to import the data into
Import Database: a database in MS Access from which you will be using the Import and Validate software.
You can do Destination database = Import Database, but that way you will be making changes to your Access database application, which you will normally try to avoid.
Your Import database (subsystem) in Microsoft Access will contain
Tutorials on how to work with Import and Validate |
---|