Create a new Import database in Microsoft Access

  1. 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.
  2. Use Import and Validate Installer to make Import an Validate available in the new database.
  3. 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

Setting up a new Import Database