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
