Solved

Exporting mysql.sql file to excel

Posted on 2007-11-27
4
167 Views
Last Modified: 2012-05-05
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
Comment
Question by:Rowby Goren
  • 2
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
Muhammad Wasif earned 500 total points
ID: 20358732
phpMyAdmin www.phpmyadmin.net will do that.
0
 
LVL 20

Assisted Solution

by:Muhammad Wasif
Muhammad Wasif earned 500 total points
ID: 20358740
phpMyAdmin is web based application, for desktop you can use http://www.convert-in.com/sql2xls.htm but this is not free.
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 20361275
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
 
LVL 9

Author Closing Comment

by:Rowby Goren
ID: 31411203
Thanks for both solutions - the local and webbased.  
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now