Updating tables from CSV file or excel
Posted on 2006-06-09
I have an excel sheet which contains product codes and NEW Selling price
i want to update the tables
its only two tables
how can i do it?
Field name "S_current_sp" Table name " Product_master " as pm
Field name "Current_sp" Table name " Product_detail" as pd
Joining details are
pm.prod_id = pd.product_id
PROD_CODE is the field which i will have in excel and its Selling Price
but i want to update both table fields as i mentioned above, i am doing it by one by one can i automated it please as i give the path of the file from where it can be taken and update the tables.