Re: mysql to cvs file to excel
| From: | Fredrik de Vibe | Date: | Fri, 21 Feb 2003 10:09:56 +0000 |
| Subject: | Re: mysql to cvs file to excel | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25821@lists.php.net to get a copy of this message | ||
Mark.Snijders@atosorigin.com (Mark Snijders) writes:
> does anybody know if it's possible (without php) to export data from
> mysql to a cvs file, so i can import it in excel???
Not a cvs file, that's for sure, but I guess you mean csv. You can of
course script this with other languages than php, but you can use
mysqldump with the -T option to get a tab separated file, according to
the manual. Excel can to my knowledge import tab separated files.
--
--Fredrik
... and furthermore ... I don't like your trousers.