Hi
I can write an application in visual basic, The application will take the vendor's file , connect to your webserver, download the data to an access table, update the table by comparing it to the vendor's file and then give you a text file with the new data file in csv format. Apart from this I can generate an Excel compatible csv file which will have a list of products marked as new or marked as obsolete as the case may be
Thanks
Rajesh