View Full Version : Way to fill blank flds w/dflt when appending data to tables?


Sonny Jim
01-20-2010, 07:20 AM
Is there a way to fill blank fields with default values while appending data to a table?

Sonny Jim
01-20-2010, 10:00 AM
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.

dcb
01-20-2010, 10:08 AM
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

Sonny Jim
01-23-2010, 03:20 AM
Thanks for the heads up dcb! I am pasting the Excel data using "Paste-Append" from the table's File menu.

chundusmgs
02-01-2010, 07:46 AM
in the design viw enter the default value and also required to yes.

chundusmgs
02-01-2010, 07:48 AM
design view of the table enter the default value. enter yes in the required property.

smig
02-01-2010, 10:38 AM
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.