I am really a newbie at all this, so please bear with me if this seems silly
I am a web designer (just starting) and am doing an e-commerce web site with the usual databases, products etc. The thing is, the updataded price list from the supplier that my client uses is e-mailed to him in an excel file every week. So what I need to know is how to integrate mysql with excel, so I can import the excel file into the mysql database, and it updates the prices, also informing me of any products that aren't there any more, and informing me of any new products that I need to add. It would be good if it did this all automatically, (deleting discontinued products in particular), of course I would like it to update the prices automatically as updating over a thousand prices every week wouldn't leave any time to do anything else!!!
Please help me, this is something I need to get sorted asap.
I have looked at the mysql manual etc, but I can't seem to find anything related to this.
Thank you
Hannah