>>>>>>>>>>>>>
IS it true when using insert into that you have to account for all the fields even thought you want to leave some of them blank? I have a dbf with 30 fields and want to insert a new record and I only care about say 5 fields, I have to provide a value for each 30?
>>>>>>>>>>>>>

No, it's not true as Nick and Cetin said. Besides their comments, remember that any defaults, NULL settings and Insert Triggers that may be in effect apply.