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
Solved

Exporting mysql.sql file to excel

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Creating and Managing Databases with phpMyAdmin in cPanel.
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…

860 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