Set all values in table to NULL with VBA In Access 2010
Posted on 2015-01-12
I have a small table with about 73 records. I am migrating data from another data source. I want to keep the auto-numbers as these are the same in both tables. what would be the easiest was to null out all column values (there are a lot of columns). None are requires except the ID column, which is the auto-number. I know it would be a loop, but how do I loop through each field in each column of the table other than the IDDeal column?