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 <[email protected]> Date: Tue, 5 Jan 2010 13:42:20 To: <[email protected]> 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, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: Re: Exporting the result of a Query into excel To: "ishaq gbola" <[email protected]>, [email protected] 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 <[email protected]> Date: Tue, 5 Jan 2010 13:31:59 To: <[email protected]> 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 <[email protected]> wrote: From: Jay Ess <[email protected]> Subject: Re: Exporting the result of a Query into excel To: "[email protected] >> Mysql" <[email protected]> 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/[email protected]
