Rhino Get the free DBTools DBManager Pro from http://www.dbtools.com.br/EN/dbmanagerpro.php - there is a cool CSV export function there
Or get MyODBC and connect from Excel to your MySQL database Or as Scott said, roll your own exporter if you have programming skills Freddie > -----Ursprüngliche Nachricht----- > Von: Rhino [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 20. August 2004 18:30 > An: Scott Hamm; 'Mysql ' (E-mail) > Betreff: 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]