how do I combine 4 files into a single table?
Posted on 2011-04-29
I have 4 product files, each file is 20,000 lines. The files
product file 1
description file 2
price file 3
inventory file 4
product_id, quantity, location
I need a single table that looks like:
product_id, short_description, long_description, price, quantity, location
Note that in file 3, the product_id isn't in the first column.
This isn't a school test, I am trying to help a friend upload some data into an Intuit web "store" and they are very specific about how they will accept a file. It has to be a comma delimited file. I figured it would be easier to pull these flat files into a data base and then export it as a comma delimited file but I am stuck trying to figure out how to merge the tables.
Thanks in advance for your help