multiple infiles into a same table/record

hi,
i have a requirement that i have to load data from multiple datafiles into a table and the records are matched between the datafiles using a column.(say something like if the first 5 characters of a physical record in datafile1 matches with first 5 characters of datafiles2, it means both should be joined and put into the same record. has anyone done this? any insight into how to do this? thanks, Received on Fri May 28 2004 - 01:26:57 CDT