>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.

The last column in the Table Designer identifies if a column accepts nulls or not. To allow nulls, select a field and check that (NULL) checkbox.