Sorry. I will 'plain what I'm doing in:

I am opening up a text file that has the data, about 57k lines/records. I am attempting to append that text file into an empty table. The problem comes in that the format of the text file is what I explain beofre and some of the data is getting in clean and some isn't.

I thnk I need to be able to scan through the table (after all the text data has been appended) and convert all those fields that have the incrroect format to the correct format:

scan testtable
for field(x)
correct format
endfor
endscan

or something like that....does that clear things up a little bit?