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 <lists@stripped> wrote:
From: Jay Ess <lists@stripped>
Subject: Re: Exporting the result of a Query into excel
To: "mysql@stripped >> Mysql" <mysql@stripped>
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=1
