I have a text file that contains 6 records per line. Each field is separated by a "!". I need to be able to read each line (record), set a variable to each field, and then insert a new reocrd into a sql database using the variables.

I appreciate any help!