Alicia wrote:I need you guys to advise on this. I have downloaded and edited one of the db by using MS Excel.. Now i wanna upload it back to existing table, how could i do that ???
For your information, i am using myphpadmin.. i dun see any link i can click to upload my db.. i know how to dump but dunno how to upload back,,,
I'm going to assume that you're using MySQL, since you mentioned PHPMyAdmin. Here's the problem: MS Excel is a spreadsheet application. It's not a database application. It's not intended to edit database information and should not be used as such for any reason. I can only assume that you downloaded the data as CSV or tab-delimited or something in order to open it into Excel. It's not going to be easy to get it back into MySQL. Essentially you're going to have to delete all of the rows in the entire table and then do some pretty complicated transforms in order to get it into some format that MySQL understands (e.g. INSERT statements).
In other words, you went at this problem entirely in the wrong direction. If you wanted to modify the information in the database, you should have done so directly, using SQL queries through PHPMyAdmin. Do not use Excel to edit the contents of a database -- you can think of this as the equivalent of using Photoshop to write a mathematical proof. It's just too difficult to bother.