in reply to mysql dump in excel format

I believe MySQL has a native dump mechanism that will dump to CSV (which Excel can read). If not, it's a six lines of code with DBD::CSV
use DBI; my $mysql_dbh = DBI->connect( ... mysql_dsn); my $csv_dbh = DBI->connect( ... csv_dsn); my $mysql_sth = $mysql_dbh->prepare( ...mysql_select_sql); $mysql_sth->execute; $csv_dbh->do("CREATE TABLE excelsheet AS IMPORT(?)",{},$mysql_sth);