Re: export mysql to excel
| From: | Torsten Roehr | Date: | Fri, 14 May 2004 08:42:18 +0000 |
| Subject: | Re: export mysql to excel | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-186217@lists.php.net to get a copy of this message | ||
>>>
"Curlybraces Technologies Ltd" <curlybraces@dialogsl.net> wrote in message
news:015601c43972$dd59ee90$0d1ea8c0@killall2000...
hi ,
i want to export data in mysql to excel .. but problem is mysql runs in the
linux machine ,
How can i get that data from mysql-Linux machine to windows-Excel machine ,
plz help asap
thanx in advance
curlys
<<<
Usually it's just selecting all records and writing them in a plain text
file spererating the values with commas (Comma Seperated Values), each
record in a seperate line. The file extension should be .csv. Then Excel
will open it as a spreadsheet.
But I think it's worth a try to follow the advice of Marek to try out an
existing class for this task.
Take a look here:
http://www.phpclasses.org/search.html?words=excel&go_search=1&x=0&y=0
Regards, Torsten