Is it possible to have a script import the contents of a text file into a text field in a script?

 

If this isn't directly possible, are there any neat tricks/hacks/plug ins, that effectively make it possible?

 

(I don't want to create new records, I want to import corresponding data in text files into existing records. For example if field "A" is "Blue", I want to be able to have a script set text field "B" as the contents of C:/Blue.txt)

 

I need this to be done to thousands of records.

 

Also, I have no problem changing the extensions of the txt files to something else, if that would help.

I think I was able to solve this by creating a related table with two fields and importing a folder with all the text files (one field for the file names and one for the contents).

 

I'm still disappointed that, as far as I can tell, this can't be easily done within a script.