I have a load of text files that contains one record per file . Each field data is separated by as follows !!:number:Field data!!. I need to be able to read each line (record), set a variable to each field, and then insert a new reocrd into an access database using the variables. How can I set my variables to their corresponding values from the text by searhing for !!:number:Field data!! ?? I appreciate any help! I know that it has to do with parsing the text files, but I just amn't sure how to go about doing it!!!

Thanks a million,
JK

[Edited by kanejone on 11-29-2000 at 05:10 AM]