Skip navigation links

MySQL Forums :: Other Migration :: Export a MySql table to an Excel spreadsheet


Advanced Search

Re: Export a MySql table to an Excel spreadsheet
Posted by: Bob Field ()
Date: August 28, 2006 02:14PM

Use a SELECT ... INTO OUTFILE ... statement to write a CSV file or a tab-delimited file that you can open directly in Excel.

http://dev.mysql.com/doc/refman/5.0/en/select.html

Options: ReplyQuote


Subject Views Written By Posted
Export a MySql table to an Excel spreadsheet 67490 es shoe 08/25/2006 09:50AM
Re: Export a MySql table to an Excel spreadsheet 40849 Bob Field 08/28/2006 02:14PM
Re: Export a MySql table to an Excel spreadsheet 27884 Jose Blanco 12/07/2006 03:39PM
Re: Export from a spreadsheet to mysql 19987 Patrick Armah 03/08/2007 06:00AM
Re: Export from a spreadsheet to mysql 20720 Peter Lavin 04/06/2007 02:20PM
Re: Export from a spreadsheet to mysql 14640 Georgi Tomov 04/06/2007 03:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.