Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
> A command to convert the table mytab in database mydb into a tab-delimited
> file mytab.txt might be:
>
> mysql -e'select * from mydb.mytab' -sss > mytab.txt
>
> The -sss is necessary to remove all the formatting stuff that you normally
> have in the output of a select statement.
>
> An alternative, if you have a directory *** that mysql can write to ***:
>
> mysqldump --tab="/home/mysql/temp" mydb mytab
>
> This will create 2 files in /home/mysql/temp: mytab.txt and mytab.sql. The
> one you'll want is in mytab.txt.
>
> Then use what transfer tool you have, ftp, scp, winscp, rsync to transfer
> the file to another server.
>
> On Tue, Jan 5, 2010 at 7:31 AM, ishaq gbola <ishaqgbo@stripped> wrote:
>
>> 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
>>
>>
>>
>>
>>
>
>
>
>
