Changing Order of Columns in a table in Administrator

[eshoenig]

Ok I have searched and searched and can not seem to figure out how to do this. I have a table designed in MySQL Administrator and I realized that I have to insert a column (row) in the middle of the already saved table. The reason I have to do that is because the columns must be in a certain order for when I import a text file into it! How do I add a column? There doesnt seem to be any option for inserting a row in mysql admin.

Thank you much for your help.

Estee