RE: [PHP] Print MySQL DB as Exel File?

> Could anyone help me out with how to print the entire contents of a > database as an Excel file? I'm familiar with the header: > > header("Content-Type: application/vnd.ms-excel"); > > just not sure how to go about it beyond that. I have this code and > am not sure what do do after it. Thanks. Excel spreadsheets are in a proprietary format as far as I know. However, if you output the database one line = one row, and tab delimit the lines, Excel will notice you're importing a text file and give you some appropriate options (select delimiter, etc). I'd go for tab delimiting over comma delimiting, since your text fields will probably contain commas but will *very* *exceedingly* rarely have tabs. I've ripped some code out of phpMyAdmin to do this (ta Tobias, if you're watching ;)) - I can post it if you want to. Jason -- Jason Murray jasonm@melbourneit.com.au Web Design Team, Melbourne IT Fetch the comfy chair!