When a table with columns not null is created and set as primary key, running the Import Wizard for an Excel spreadsheet with null values in that column and choosing to "Skip This Column" in the Select Target window will generate the following error:
Null value cannot be inserted to not null column ID.
Do you want to cancel the import and re-map the column?
Click no to ignore the current error(s) and any additional errors and continue importing.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad Data Point.
