integrating mysql with Excel

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
purple_hannah
Forum Newbie
Posts: 1
Joined: Tue Jan 04, 2005 11:00 am

integrating mysql with Excel

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
Post Reply