If you have Excell you can use the Get External Data to get the data from MySQL using MyODBC.
Also you can use MSQuery to query the database and send the result to Excel. Another way would be to write a macro that uses ADO and process the results into the workbook. HTH JFernando *** sql *** -----Original Message----- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: October 29, 2002 04: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