How to convert MtSql to Excel and Vice-versa

[aloksharma]

Hello All,

I want to convert MySql to Excel and Vice Versa.

I downloaded a utility mysql-to-excel from the net but the problem is that my hosting company does not allow remote connectivity to the database.

I tried to play with the phpMyAdmin but could not get to it.

Although there is a option of export, but when i click on it, there is no space where we can specify that where the exported table should be downloaded.

I have to edit around more than 3000 rows. Doing this though the software admin is very complicated as I have to go to that page, click edit, again click edit aganist the text that needs to be edited. This wastes lot of time and bandwidth.

Is there any program that can be execute from the site itself for this purpose.

Can anyone help please?

Regards,

Alok Sharma

[konsu]

dump your database in to a file, bring it to your local machine where you can connect to mysql from the utility you downloaded, convert it, dump it from your local machine and push it in to the original database.