Is There a mysql tool that works like excel?

Discussion in 'MySQL' started by MOG, Jan 19, 2008.

0
  1. #1
    Hi, Ive downloaded a few things but nothing seems to fit the bill,

    ideally Im looking for a tool that can open mysql data in a spreadsheet type format?

    Ive played about with the excel import itself ad infinitum but never managed to get it working reliably.


    Any help much appreciated!


    MOG
     
    MOG, Jan 19, 2008 IP
  2. Krnl

    Krnl Peon

    Messages:
    60
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    0
    #2
    You need to export the mysql table that you want to look at. Export it in .CSV (Comma Separated Values) format and open it with MS Excel. You can export the table using your admin interface (phpMyAdmin or whatever you use).
     
    Krnl, Jan 19, 2008 IP
    MOG likes this.
  3. MOG

    MOG Well-Known Member

    Messages:
    2,219
    Likes Received:
    163
    Best Answers:
    0
    Trophy Points:
    180
    #3
    Do you know what mate.... Ive spent hours on several different occasions playing about with .sql files in excel, I am semi proficcient in sql as well, and NEVER EVER thought to just export the bloody lot straight out as a csv.


    1) GOD I FEEL STOOOOOPID
    2) Thanks for pointing this out... guess Im just getting too old lol!!

    MOG
     
    MOG, Jan 19, 2008 IP
  4. mbnaragund

    mbnaragund Peon

    Messages:
    46
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hi
    here is the tool which my help u


    xampp-win32-1.6.4-installer.exe click here

    this tool is having apache, mysql and some other tools .

    To know more click here
     
    mbnaragund, Jan 23, 2008 IP