----- 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]
