MySQL Forums
Forum List  »  Newbie

Re: Export mySQL to Excel
Posted by: Lee Wood
Date: November 02, 2008 12:44PM

You should be able to import a tab-separated text file into Excel.
You can create a tab-separated text file directly from a SQL query, using the SELECT ... INTO OUTFILE syntax. (see: http://dev.mysql.com/doc/refman/5.0/en/select.html )

Options: ReplyQuote


Subject
Written By
Posted
October 31, 2008 03:48AM
October 31, 2008 08:13AM
November 19, 2008 10:58AM
November 19, 2008 12:16PM
November 19, 2008 12:40PM
November 19, 2008 03:38PM
November 20, 2008 04:07PM
November 20, 2008 04:22PM
December 02, 2008 04:47PM
December 02, 2008 09:19PM
December 03, 2008 10:00AM
December 03, 2008 11:13AM
December 14, 2008 10:19PM
October 31, 2008 08:35AM
November 01, 2008 05:01AM
November 01, 2008 07:39AM
November 01, 2008 02:18PM
November 02, 2008 12:09AM
November 02, 2008 07:00AM
November 02, 2008 08:59AM
November 02, 2008 10:57AM
Re: Export mySQL to Excel
November 02, 2008 12:44PM
November 03, 2008 09:42PM


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.