Carsten:
Can you demonstrate this?
~Lawrence
Carsten Pedersen wrote:
> 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
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
