Importing mysql data into Excel file

hi..I wanted to import data from mysql to excel. How can I do that?

Hi.

Exporting data from MySQL into Excel is no problem. There are several ways to do that infact.

Excel is able to read the files created by MySQL's SELECT INTO OUTFILE statmement, so you should be able to do something like:

SELECT * FROM myTable
INTO OUTFILE '/path/to/file.ext'