I have an access table that i create from an imported .txt file. There is a field let's say Apple that is an int field and some records in this table are blank for this field. I then, from MS Access run a append query to an web table that has the same field set as int, null, with default value of 0. I would expect that any record that has the Apple field blank would be assigned my default value of 0. But, it still shows NULL. I need this to be zero if it is blank. Any ideas would be appreciated. thanks.
