Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

MySQL to Excel?

davidrtgdavidrtg Member Posts: 95
Anyone know of a way to take a database from MySQL and export/convert it to an Excel database? I'm thinking somehow export the database to a comma delimited text file then importing it into Excel. Which are both something that i'm not to familiar with.

Any help would be apreciated.

Thanks,
David

Comments

  • JonathanJonathan Member Posts: 2,914
    : Anyone know of a way to take a database from MySQL and
    : export/convert it to an Excel database? I'm thinking somehow export
    : the database to a comma delimited text file then importing it into
    : Excel. Which are both something that i'm not to familiar with.
    Comma delimited or tab delimited will do you fine, I'd imagine. Tools like phpMyAdmin will create a comma or tab delimited dump of a database table for you, and then Excel has an import wizard.

    How are you looking at the MySQL database at the moment?

    Jonathan


    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

  • davidrtgdavidrtg Member Posts: 95
    : : Anyone know of a way to take a database from MySQL and
    : : export/convert it to an Excel database? I'm thinking somehow export
    : : the database to a comma delimited text file then importing it into
    : : Excel. Which are both something that i'm not to familiar with.
    : Comma delimited or tab delimited will do you fine, I'd imagine. Tools like phpMyAdmin will create a comma or tab delimited dump of a database table for you, and then Excel has an import wizard.
    :
    : How are you looking at the MySQL database at the moment?
    :
    I'm looking at it with phpMyAdmin. I'll take a look and see what can be found there.

    : Jonathan
    :
    :
    : ###
    : for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    : (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    : /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");
    :
    :

  • davidrtgdavidrtg Member Posts: 95
    : : : Anyone know of a way to take a database from MySQL and
    : : : export/convert it to an Excel database? I'm thinking somehow export
    : : : the database to a comma delimited text file then importing it into
    : : : Excel. Which are both something that i'm not to familiar with.
    : : Comma delimited or tab delimited will do you fine, I'd imagine. Tools like phpMyAdmin will create a comma or tab delimited dump of a database table for you, and then Excel has an import wizard.
    : :
    : : How are you looking at the MySQL database at the moment?
    : :
    : I'm looking at it with phpMyAdmin. I'll take a look and see what can be found there.

    phpMyAdmin rocks! Exports the database to a csv file that excel reads. Thanks for pointing me in the right direction Jonathan!
    :
    : : Jonathan
    : :
    : :
    : : ###
    : : for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    : : (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    : : /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");
    : :
    : :
    :
    :

  • JonathanJonathan Member Posts: 2,914
    : phpMyAdmin rocks! Exports the database to a csv file that excel
    : reads.
    Great. :-) I was certain I'd seen the option to do it in there somewhere...

    : Thanks for pointing me in the right direction Jonathan!
    You're welcome.

    Jonathan


    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.