extract from MySQL to excel file

[eklee]

Hi,

How can i extract the data from MySQL directly into Excel format, or other format of file? Any example or advise is appreciateble.

THanks
Louis

[[deleted]]

You can dump data in CSV format using SELECT INTO OUTFILE

http://www.mysql.com/doc/S/E/SELECT.html

[aspbyte]

use Myodbc available from Mysql.com

[eklee]

Vincent,

can show an example on how to do it? and able to let the user to download it?

Thanks
Louis

[[deleted]]

Just use SELECT INTO OUTFILE to output the data in a comma seperated file, give it a '.csv' extention and point the user to it with a URL.

Do a search for more info, this has been done before by others.