Create a new Import database in Microsoft Access
- Create a new (Import) database in Microsoft Access. Decide which folder you
want to work from. Give a suitable name to the database to reflect the import
project you will work on.
- Use Import and Validate
Installer to make Import an Validate available in the new
database.
- start the Import and Validate
software from the ribbon or menu. If there are no tables yet in the
database, this will open the [Create Linked Tables]
dialog to add tables to your Import database that are connected to the
database you want to add data into, the Destination database. If there already
are tables in the database, the Import Validate main form opens.
Next: Add linked tables
for the source and destination tables