Solution: While viewing a table in the data sheet view, move all the fields anticpated to be blank to the right and paste append only the fields with data. Then the blank fields are not written to and they are populated by their default values.
So you are not actually doing an append - rather copy paste.....
If you are doing this from Excel watch out for a security update that seems to pitch up once a year from MS that stops you from being able to do such...
Just FYI if you are realeasing to an external party
if you fill the table from another source setting the default value won't help.
after you finish filling the table run a quick Edit Query and edit all empty fields to the default value you want.
