I've got a | delimited file that I am using to import into a sql table. The problem is that there are three fields (UPC, Location & QOH) that I am concerned with. The table that I need to update, I have to first convert the UPC in the file to an id located in another table and then convert the Location into another id located in a third table and then update the QOH based on the two ids in the first table. I know how to do a straight import from a text file into a single table, but I can't figure out how to look up the values in the other two tables for the reference fields. Any help would be greatly appreciated.