Page 1 of 1

integrating mysql with Excel

Posted: Tue Jan 04, 2005 11:25 am
by purple_hannah
Hi there,

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

Posted: Tue Jan 04, 2005 11:29 am
by feyd
mysql cannot and will not import excel directly. You can use a php extension to potentially load the data, however I'd recommend exporting the excel data to a more simple text file that is easily dealt with in php. Something like say, a CSV.

Searching through these forums for [devnet]excel[/devnet] will bring up the hundreds of threads we've had about Excel.