I've got to update a website with brand new price information shortly from data kept in Excel. I was wondering if the following method was a reasonable way to do things
1) Export current price table
2) Use a VLOOKUP to replace the old price info with the new price info
3) Delete all the data in the web table
4) Upload the new table via phpmyadmin
Alternatively, could I write a formula to construct the MySQL statement required to UPDATE the exsisting lines UPDATE price=newprice IN price_table WHERE stock_code = 'blah'
Which one is likely to be a better method or doesn't it really matter?


LinkBack URL
About LinkBacks
Reply With Quote
