Re: export mysql to excel

From: 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

« previous php.general (#186217) next »