Hi, I have a big problem that I hope someone can help me with.
Every day I receive a product listing (updated) to reflect the stock availability and the new or deleted products. This file contains on average about 10,000 entries using four columns.
My problem is that I have to update the previous days spreadsheet with the new spreadsheet. Thus removing or adding the new entries.
As you can imagine on this scale this is more than tedious.
The reason I cannot simply just replace the data is that the 4 columns are then added to an existing spreadsheet which in turn is then used in mysql database.
So all information must be retained in the existing data and I only need to know which new or deleted item have occured in the new spreadsheet.
I hope I have explained this clearly!!!
Thanks
Bookmarks