MySQL to Excel?

Comments

• Jonathan

  October 2003

  : 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.");
  
  
• davidrtg

  October 2003

  : : 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.");
  :
  :
  
  
• davidrtg

  October 2003

  : : : 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.");
  : :
  : :
  :
  :
  
  
• Jonathan

  October 2003

  : 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.");