List:General Discussion« Previous MessageNext Message »
From:sureshkumarilu Date:January 5 2010 1:50pm
Subject:Re: Exporting the result of a Query into excel
View as plain text  
Ok. In windows, Use winscp tool, connect to the server and copy the file to local machine and import it in excel.
Thanks
Suresh Kuna
Sent from BlackBerry® on Airtel

-----Original Message-----
From: ishaq gbola <ishaqgbo@yahoo.co.uk>
Date: Tue, 5 Jan 2010 13:42:20 
To: <mysql@lists.mysql.com>
Subject: Re: Exporting the result of a Query into excel

Am running windows on my local host and Redhat linux on the remote server, I have no mysql client on local host. TAC for the NMS using the database adviced me not to use a msqlclient for it, that it could break the database??? 

--- On Tue, 5/1/10, sureshkumarilu@gmail.com <sureshkumarilu@stripped> wrote:

From: sureshkumarilu@stripped <sureshkumarilu@stripped>
Subject: Re: Exporting the result of a Query into excel
To: "ishaq gbola" <ishaqgbo@stripped>, mysql@stripped
Date: Tuesday, 5 January, 2010, 13:37

Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?

Thanks
Suresh Kuna
Sent from BlackBerry® on Airtel

-----Original Message-----
From: ishaq gbola <ishaqgbo@stripped>
Date: Tue, 5 Jan 2010 13:31:59 
To: <mysql@stripped>
Subject: Re: Exporting the result of a Query into excel

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@netrogenic.com>
Subject: Re: Exporting the result of a Query into excel
To: "mysql@stripped >> 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=1gbo@stripped










Thread
Exporting the result of a Query into excelishaq gbola5 Jan
  • Re: Exporting the result of a Query into excelJay Ess5 Jan
    • Re: Exporting the result of a Query into excelishaq gbola5 Jan
      • Re: Exporting the result of a Query into excelJay Ess5 Jan
        • Re: Exporting the result of a Query into excelishaq gbola5 Jan
          • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
      • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
      • Re: Exporting the result of a Query into excelJim Lyons5 Jan
        • Re: Exporting the result of a Query into excelCarsten Pedersen5 Jan
          • Re: Exporting the result of a Query into excelLawrence Sorrillo5 Jan
          • Re: Exporting the result of a Query into excelJim Lyons5 Jan
  • Re: Exporting the result of a Query into excelJim Lyons5 Jan
  • RE: Exporting the result of a Query into excelJason Trebilcock6 Jan
Re: Exporting the result of a Query into excelishaq gbola5 Jan
  • Re: Exporting the result of a Query into excelsureshkumarilu5 Jan
  • Re: Exporting the result of a Query into excelMichael Dykman5 Jan