Solved

Exporting mysql.sql file to excel

Posted on 2007-11-27
4
168 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL backend - what should be front end? 8 52
MySQL Select latest stock count records 11 55
Mysql sync between 3-4 mysql db 4 23
sql_mode 1 16
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 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

22 Experts available now in Live!

Get 1:1 Help Now