>I have a table that has a .NULL value in some of the fields. Therefore, my string for the INSERT command to the SQL server comes back with an error.” More columns in the insert than the values….” that is, it does not read the fields with the .NULL
>What should I do in this case?

Can you use nvl() function? Just a thought...