MySQL ODBC Connector - Excel to MySql update

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Excel to MySql update

andrianm@gmail.com

2006-02-28, 8:28 pm

Hi, I have a problem I have an excel worksheet which is brought to me
every week with new changes (prices, or new products added) this
information is supposed to be on the website which is working on
php/mysql. I found a couple of things how to import from excel to Mysql
but how do I update information. Also what if worksheet doesn't just
have products and prices bu also categories? How will be the best way
to keep it up to date. thak you.

Sponsored Links