I should mention,
It sounds like what you want to do is modify your table like a spreadsheet. This can be done, but it's ugly, slow, and could be done with much less trouble by simply running the query in my previous post.
To do it this way, you would need to use a program such as Navicat and copy the entire contents of a table to an excel spreadsheet. You will occasionally run into problems when attempting to paste certain types of data... You would then need to modify the data accordingly in excel, clear the appropriate data from the original table, then paste it in. It's very ugly and not very reliable, so I don't recommend this method.
|