Thanks a lot for that, but where does this file get saved in and how can i copy it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess <li...@netrogenic.com> wrote: From: Jay Ess <li...@netrogenic.com> Subject: Re: Exporting the result of a Query into excel To: "mysql@lists.mysql.com >> Mysql" <mysql@lists.mysql.com> Date: Tuesday, 5 January, 2010, 13:22 ishaq gbola wrote: > Hi all, > > I would like to know if there is a tool or command in mySQL that allows one > to export the result of query into excel formart > select * from table into outfile "thefile.txt"; That can be imported into excel using CSV and using "TAB" as separator. http://code.anjanesh.net/2007/12/export-mysql-data-to-excel-compatible.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=ishaq...@yahoo.co.uk
