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.