I tried using "myVariable = CStr(csvField)". It still does not work. It assigns the previous record's 5 digit zip to the next record having 9 digit zip code. It does not accept any 9 digit zip instead assigns previous records 5 digit zip to that record.
|