How do I enable all the import modes available in the Import Wizard?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium

Solution

In order to activate the remaining options in this step in Import Wizard, you must enable Primary Key in the previous step. Navicat would need primary key in order to locate the record for deletion or update action.

This only applies to situation when you import your data into an existing table or collection.