Note that based upon this thread, I downloaded and installed MyODBC (simple Google search), configured a DSN, created an Excel query, and loaded the DB into the worksheet in under 5-minutes total time. While I don't use Excel that much for anything, it was a very simple exercise and might prove handy for some things.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters USA Central Time Zone 636-922-9158 ext. 8652 fax 636-447-4471 [EMAIL PROTECTED] www.nisc.cc ----- Original Message ----- From: "Eamon Daly" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 13:55 Subject: Re: Brainstorming' time! > 100 quatloos to Chris for the simplest answer. Do that. > > I'll add that you could also use mysqldump: > > mysqldump -T /tmp test users > > This would create /tmp/users.sql, containing the CREATE > TABLE, and /tmp/users.txt, containing a tab-delimited file > suitable for import. No header row, though. > > And, apparently, my perl solution completely reinvented the > wheel. See pp.527-530 "MySQL Cookbook", 1st ed. for a > better script. > > ____________________________________________________________ > Eamon Daly > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Friday, August 20, 2004 1:24 PM > Subject: RE: Brainstorming' time! > > > > 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. > > > -- > 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]
