Update the database data with an excel sheet

[searain]

Hi, I have a product table with product code and price etc.

Now I have an Excel sheet with the same product codes but new price.

1) Are there some database tools/software/scripts I can use to update the database data with an Excel sheet?

2) I can upload the excel sheet to create a new table. So my next question is are there any database tools/software/scripts to let me update table1 with table2?

3) I know I can write a php script to update the my specific old table with the new table price. But I would like to know if there is popular standard general purpose tools, so I can use it for this general purpose, update table 1 with table 2 (general purpose)

[searain]

to be specific, i am looking for a mass update tool. Any help?

[searain]

Any help? This should be a popular request.

Insead of to update online database record one by one, upload the excel and use this information to mass update the whole database.

[tltran]

Hi you can export your excel file ton csv format and then
you php to parse each field for each row

$ar_record = file(yourexcelfile);
for($i=0;$i<count($ar_record);$i++){
$record = $ar_record[$i];
// parse your line, explode(",", $record) or something more powerfull.
// then build your insert sql query with your data

}