Ok unless I missed something here, wouldn't you just use the "SELECT ... INTO OUTFILE" Syntax found here http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Just search for "outfile" and you can find it faster. You can run a query against a table and save the output into a file and in the case of creating excel type data, just save it into a file with the fields separated by commas, a CSV file in other words. Then use excel to open the file. Chris Hood Investigator Verizon Global Security Operations Center Email: [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for the use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 11:30 AM To: Scott Hamm; 'Mysql ' (E-mail) Subject: Re: Brainstorming' time! ----- Original Message ----- From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 12:02 PM Subject: Brainstorming' time! > Ok. I'm looking into alternatives. I'm trying to figure out an alternative > to mysql exporting into xls file. Is there any another way you can export > into file and make it readable? What format do you use? I'm open to ideas > from experienced database programmers :) I'm upgrading the whole database > system from stupid Access "database" into SQL variant, whether it be MySQL > or SQL server (MeowSoft) > How do you export a MySQL table into an XLS file? ;-) You raised an interesting point - the whole issue of exporting data from MySQL - so I took a quick glance and couldn't see *anything* that looked like an export utility of the kind I've seen in many other programs and relational databases. Just about the only thing I saw was the mysqldump utility which basically generates the SQL needed to re-create and re-populate a table on another system. But I don't think that's what you're looking for and it clearly won't generate an XLS file. So I'm not sure how you'd even export to XLS. In the absence of an actual export utility - assuming I haven't missed one in the manual somewhere! - you are hosed. Unless of course you have programming skills; in that case you could write your own export utility to export data in any format you like. If you do that, you might consider sharing it with the rest of us when it is done, even if it isn't a full-function ultra-slick piece of code; it might still be useful to some of us if we ever need to export data. Or maybe there are some export utilities floating around for MySQL that are described somewhere other than the manual. I could well imagine users developing their own homegrown utilities and donating them to MySQL. I can also imagine professional developers writing a full-function export utility for MySQL; a Google search might turn those up. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
