Sorry about the vagueness, I tend to do that when I'm new to a task. To answer your questions:


1. both files are comma delimited files.
2. file1 fields= id,name,type
file1 values= 1,yeates,scarborough
2,wayman,freedom
3,xena,princess

file2 fields= name,ref#,organization,type,box#
file2 values= wayman,34,meade,B1,4
wayman,56,gs,B2,7
wayman,78,nine,B3,8
yeates,52,sample,A1,9
xena,63,tv,C1,7
xena,22,media,C2,2

3. Right now the only code I have is reading the files into a string. That's all I've got because I want to figure out the best way to do this. File1 will be very small..100k. File2 will be larger than 40megs.

Does this clarify some vagueness?

Thanks.