Exporting mysql data to excell files

[Anon]

Hey there,
Can it be done?
I want to export the contents of a mysql table to a .xls file.
I seem to be going round in circles!
Only a beginner so could anyone please tell me how and if this can be done in detail 🙂
Or else point me in the right direction.

Many thanks
Kev.

[gushy]

You can't export to an .xls file but you can dump the data to a CSV or tab delimited file, which you can read with Excel.

[Anon]

Could anyone please elaborate on how to accomplish this?

[Anon]

In case you still wanna know...

$fp=fopen($targetfile,"w");
mysql_connect('',$User,$Pwd);
$Qry="select * from Tablename";
if (($P = mysql_db_query($Dbase,$Qry))&&($R = mysql_fetch_row($P))) do {
$fileline=implode("\t",$P);
fwrite($fp, "$fileline\r\n");
} while ($R = mysql_fetch_row($P))
mysql_close();
fclose($fp);

Maybe this can be optimized somehow - I am beginner myself