I am attempting to append records from a remote view where some of the records in the source table have Null values.

Where all the values in a column are not null they import fine. But if some of the values in a column are Null then I get an error message e.g. 'Field2 does not accept Null values' .

I have tried to look at the table designer and I can't see how to modify the structure to make the fields accept null values. All of the fields in the receiving table are character fields 30 characters wide.

Mike Smith