MY-SQL query to export data in excel file

Question

I am able to export table's data into CSV file but unable to export these data into excel file. Is here any query to export these data into excel file.

I am using 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 excel file after change file name like your-filename.xls but its adding extension .xls but giving data like csv.

I know CSV file open up in excel but I have some special character like Chines etc which does not support by CSV either I open this into excel. So I want pure excel file for this character. — Khoyendra Pande
– Khoyendra Pande, Commented Dec 5, 2011 at 5:36

aleroot · Accepted Answer · 2011-12-05 05:44:46Z

1

You cannot export your query result set directly in excel with SELECT INTO ... You can export in CSV format that can be easily opened by excel as you already done, but you cannot export directly in excel format.

answered Dec 5, 2011 at 5:44

aleroot

73k32 gold badges182 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Khoyendra Pande Over a year ago

I know CSV file open up in excel but I have some special character like Chines etc which does not support by CSV either I open this into excel. So I want pure excel file for this character.

aleroot Over a year ago

pure excel file can't be exported with a query, sorry... You have to process the data in the resultset in your java program and then export it in excel from there ...

hkulekci · Accepted Answer · 2011-12-03 20:06:41Z

0

you can use a converter csv to xls?

php example : http://www.performantsystems.com/CSVtoXLS.html
file parameter base example : 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

answered Dec 3, 2011 at 20:06

hkulekci

1,96215 silver badges28 bronze badges

1 Comment

Khoyendra Pande Over a year ago

I can't use this scrip because I am writing code in Java so I want query only.

Collectives™ on Stack Overflow

MY-SQL query to export data in excel file

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related