Multiple Data Files

Hello

I have several delimited text files, each file has a primary key with other fields, everything is correctly referenced across the files, each file represents a table in a database they were exported from.

Please allow me to simplify this, the table I want to import to have 3 fields, ID, Price, Name. I have two delimited files with the following fields, File 1: ID, Name, Description; File 2: ID, Weight, Price, Tax. How do I import into the table, the Name from File 1 and the Price from File 2?

Any ideas would be much appreciated.

Thanks