Whoops - sorry... I meant use "select field1,field2 into outfile '/somepath/somename.xls' from table1 where this=that;"
Select into outfile is explained here http://www.mysql.com/doc/en/SELECT.html Please don't use mysqldump - that was my mistake (writing two emails at once - sorry!) Andrew, Sql,query -----Original Message----- From: Andrew Braithwaite Sent: Tue 29 October 2002 09:58 To: 'Ma, Billy'; [EMAIL PROTECTED] Subject: RE: Query and export to a Excel file Hi, You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump the file into a tab delimited text file or cvs. You will be able to open it in excel in those formats. Alternatively (if you want to get a bit more involved) there is a perl module you could use called Spreadsheet::WriteExcel which will allow you to render a generic excel spreadsheet with query results and whatever formatting/formulas you want in the spreadsheet too. Hope this helps.. Andrew sql, query -----Original Message----- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: Tue 29 October 2002 09:41 To: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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