I'm using Configuration Packages in Dynamics NAV 2017, and exporting/importing Excel files to update table data. This has worked fine in most circumstances, but I have a table with a column of data I want to clear out/erase. The column needs to be there but should have no values.
I've tried exporting my table with the column, removing the existing values and re-importing with the column totally blank. That doesn't work as everything is still there.
Is there a special character or some other way to overwrite values with nulls?