You can export using SELECT fieldlist INTO OUTFILE "filename" FROM table;
This will create a file with tab separated fields. It is Excel default separator. Within Excel, you can open the file, by giving filetype text, and a wizard will guide you through the translation. You can create a CSV file by adding , at the end of the SQL statement, FIELDS TERMINATED BY ',' ENCLOSED BY '"' Giuseppe --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php