Oscom CSV XLS (2)

We have an xls file from the product distributor which contains part number, price and product description.

We need a simple program (possibly an Excel macro) which takes the xls file and compares it with an oscommerce csv dump, updates the price field if the part number exists, and ouputs a record which which has extra fields which tell us that

a) the part# exists and has been updated;

b) the part# did not previously exist;

c) the part# is not in the new price file (indicating it no longer exists).

We would like to then have the option to output a file in exactly the same format as the input file so that it may be incorporated into the database with as little effort as possible.

The files will be processed locally on a Windows machine prior to incorporation back into MySQL.

Taidot: Excel, Ostoskärryt

Näytä lisää: file xls2 type, xls, simple csv, distributor, csv, excel macro csv, mysql dump csv, macro excel database, csv file input, csv product, excel record macro, excel database input, csv xls macro, need distributor, input output macro excel, excel input output macro, input files excel macro, excel macro simple, mysql file input format, macro excel format, excel macro part, file csv, excel input mysql, macro format, excel csv xls macro

Tietoa työnantajasta:
( 20 arvostelua ) Byron Bay, Australia

Projektin tunnus: #421954