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: Reply•Quote


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


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

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.