sku price quantity weight
A001 10 2 1
A002 5 1 1
A003 3 3 11
I have the following table that gets new data in an tab delimited text file everyday. I am looking to import new data & append existing data into this Inventory table daily.
What steps would I have to take to import new data & update existing data? Once that is done, I'd like to setup a daily job to perform the import into the Inventory table.
Thank you for your suggestion & pointers.