Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Exporting mysql.sql file to excel

I have an mysql.sql file that I would like to export to an excel (or Access) file..

I've seen some programs out there that apparently do this.  However, they seem to require that the mysql still be on the mysql server.  

All I have is the file itself.  While I suppose I could set up a local mysql server on my windows machine, all I really want to do is turn that mysql.sql file into a excel (or Access) database.

Any utility out there that does this?

Thanks

Rowby
0
Rowby Goren
Asked:
Rowby Goren
  • 2
  • 2
2 Solutions
 
Muhammad WasifCommented:
phpMyAdmin www.phpmyadmin.net will do that.
0
 
Muhammad WasifCommented:
phpMyAdmin is web based application, for desktop you can use http://www.convert-in.com/sql2xls.htm but this is not free.
0
 
Rowby GorenAuthor Commented:
Hi wasifg,  got the convert-in program.  I think I will have to install a version of mysql on my local computer so I can use this utility.   Where and how do I get mysql for my windows (vista) based computer.


Rowby
0
 
Rowby GorenAuthor Commented:
Thanks for both solutions - the local and webbased.  
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now