Solved

Exporting mysql.sql file to excel

Posted on 2007-11-27
4
171 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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