Convert .sql to .xls ?

Discussion in 'MySQL' started by pharcyded, Jan 31, 2008.

0
  1. #1
    Can you do this? and if so...how? :confused:
     
    pharcyded, Jan 31, 2008 IP
  2. shallowink

    shallowink Well-Known Member

    Messages:
    1,218
    Likes Received:
    64
    Best Answers:
    2
    Trophy Points:
    150
    #2
    Did you try.. export as csv and import into excel?
     
    shallowink, Jan 31, 2008 IP
  3. pharcyded

    pharcyded Peon

    Messages:
    720
    Likes Received:
    53
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Export from where? I just purchased a database that came in .sql format...what program should I do this from?
     
    pharcyded, Jan 31, 2008 IP
  4. shallowink

    shallowink Well-Known Member

    Messages:
    1,218
    Likes Received:
    64
    Best Answers:
    2
    Trophy Points:
    150
    #4
    Take it you don't have access to a webserver running MySQL? If you do, import it using PHPMyAdmin and export using the same. How big of a database is it?
     
    shallowink, Jan 31, 2008 IP
  5. pharcyded

    pharcyded Peon

    Messages:
    720
    Likes Received:
    53
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The database is 17.1 mb and I do have access to a server that has MySQL. I will attempt to do that. thanks
     
    pharcyded, Jan 31, 2008 IP
  6. nelse

    nelse Peon

    Messages:
    87
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You can export it using phpMyAdmin (Export tab).
     
    nelse, Feb 1, 2008 IP