Can we export all tables of database into Excel Sheet ?

[naal1]

Hi Friends, :thumbsup:

 

Is there is a way to export All tables of your database into Excel Format. Means Suppose you have 30 tables and if you want to export all table at a onclick into Excel or CSV format?

 

And can we also make excel sheet name as per the table's name?

 

I knew its not a related to Oscommerce but i was searching this for last 2 month.

 

Can anyone help me regarding this.

 

Plz plz help me if you could...!!!!!!!!!1

[GemRock]

If you ever had a look at the phpMyAdmin, you would know you could export the whole database in either sql or cvs format. It is an osc related question although it may not be related to contributions support so may be better to post it to, say, the General Support thread.

 

Ken

Edited May 3, 2007 by GemRock

[naal1]

If you ever had a look at the phpMyAdmin, you would know you could export the whole database in either sql or cvs format. It is an osc related question although it may not be related to contributions support so may be better to post it to, say, the General Support thread.

 

Ken

 

Ok Ken thanks for you advice i will take care of this in future.I knew that phpmyadmin is one the best example but i want to make it independent export option.phpmyadmin has lots of pages and features too.

 

Please let me knew if you could give me any online example or source code.

 

Thanks once again.

[GemRock]

Sorry I don't think I quite understand what exactly you want to achieve, and I guess you don't either.

It takes THREE (3) clicks to download the whole database in cvs format from phpMyAdmin: Click 1 - Export; Click 2 - choose CVS; Click 3 - Go.

It would be a waste of time to make a contribution to do this simple thing. and how often do you download your database this way, rather than use the backup facility available in admin?

 

Ken