Choosing how to work with Import and Validate

When you need to work with Import and Validate on one of your Access databases, there are two ways to get started.

Choose if you will

  1. work directly from your database - or
  2. import using a separate database, connected using linked tables to your production database.
  3. work directly from your database back-end

In either case, you will use Import and Validate Installer to make Import and Validate available in the Access database you want to work from.

Note
If you want to import in a 'not MS Access' database (Oracle, SQL-server,...) only the second choice (2.) can be used

Add 4TOPS Import and Validate to your production database

Advantages:

Disadvantages:

Use a separate database for doing the imports

(preferred)

Advantages:

Disadvantages:

See Setting up a new Import Database

Work directly from your database back-end

This is only possible if the back-end is an Access database.

Advantages:

Getting Started