In Import Table Data wizard the Update, Append and Delete options are disabled. How to enable these options in order to append to an existing table with data?
For Toad 9.5 and lower:
1. In the initial screen of Import Table Data module, uncheck the "Unidirectional Import" check box.
2. In the Mappings screen of the Import wizard, ensure to check at least one field as a Primary Key field.
For Toad 9.6 and higher:
1. In the Mappings screen of the Import wizard, ensure to check at least one field as a Primary Key field.
2. In thefinal screen of Import Table Data module, uncheck the "Unidirectional Import" check box.