How to export table data to Microsoft Excel with SELECT INTO OUTFILE statement?
By Arun Desai
Hi Sir,
I am new to MySQL. I want to export MySQL Table data to Microsoft Excel. Can you explain, how to export data to Microsoft Excel with SELECT INTO OUTFILE?
Teacher SiliconIndia replied to Arun Desai Monday, November 23, 2009
Hi Desai,
MySQL SELECT INTO OUTFILE statement can help you to export MySQL table data to Microsoft Excel. It’s used when anyone wants to direct query output to a file. This file can then be opened by MS Excel, or imported into another database like Microsoft Access, Oracle, or any other delimitation supporting software. Take an example, it seems working for me with Windows XP:
SELECT * INTO OUTFILE "C:\export_table_data_excel.xls"
FIELDS TERMINATED BY 't'
LINES TERMINATED BY 'n'
FROM database_name.table_name;
The export_table_data_excel.xls will be created at C drive. If the target file path is omitted, then this file will be created at MySQL data directory.
