LOAD DATA LOCAL INFILE 'C:/Data/tmp/productSupplierFile.txt'
REPLACE INTO TABLE ec_product_supplier
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'
(
	n_product_supplier_id,
	n_supplier_id,
	n_list_price,
	n_sale_price,
	n_product_availability_id,
	b_on_web,
	n_sale_price_calculator_id,
	vch_area,
	n_currency_id,
	n_product_id,
	n_feed_id,
	n_price_priority,
  n_alternate_list_price,
  n_alternate_sale_price,
  n_alternate_sale_price_calculator_id,
  n_alternate_currency_id,
  n_cost_price
)
SET d_last_modified_date = NOW();