MY-SQL query to export data to excel file

Question

I can export the table data to a CSV file, but I cannot export this data to an excel file. Is there any request to export this data to an excel file.

I use this query to export data as a CSV file.

SELECT * INTO OUTFILE 'C:/your-directory/your-filename.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM tableName 

I used this for the excel file after the name of the change file, for example your-filename.xls but adding the extension .xls, but providing data such as csv.

Answer 1

You cannot export the result of a query result directly to excel using SELECT INTO ... You can export in CSV format, which can be easily opened by excel, as you have already done, but you cannot export directly in excel format.

Answer 2

can you use csv converter for xls?

• Php example: http://www.performantsystems.com/CSVtoXLS.html

• Example file parameters database: http://www.convert-files.com/SII/Convert-XLS/English/WebHelp/command_line_manual/examples__conversion/converting_csv__any_character_delimited__files/rhid_convert_a_csv_to_an_xls_file.htm