Bdc data upload

Hai all,

I want the claridfication abt this, ie for example, If the flatfile contains ten fields and their corresponding 10 records. In this the out 10 records, 5 of them have values for 8 fields and for the rest of the fields it have null values and the remaining five records have values for all the fields.

My problem is while uploading data through BDC for the records with values only for eight fields the system has taken the value from the adjacent field and make the value as wrong.

For the records with value for 10 fields it is uploading correctly.

Please help to clear this.

Thanks in advance,

S.Jenibalet.