My data file has two fields, but the target table has three. The one missing is a required column.
So the file looks like this...
The table is defined like this...
Col 1 = Zip
Col 2 = Address
Col 3 = Update Date (Not Null)
I have been playing around with the format file, but I can't seem to get it right. I get an error "No default value available, NULL not allowed for col 3". I tried to delete the third col from the format file and I get other errors.