Re: Dumping MySQL result set to a spreadsheet

2004-03-01 Thread Curtis Maurand
SELECT into OUTFILE " Should get you a tab delimited file there are more options for using different delimiters and field encapsulations, etc. Its in the manual. curtis On Sun, 29 Feb 2004, Joshua Beall wrote: > Hi All, > > I am wondering if anyone can point me to a utility that will le

Re: Dumping MySQL result set to a spreadsheet

2004-03-01 Thread Eric @ Zomething
Neale Banks wrote: > Should we presume you haven't noticed the, admittedly not widely > publicised, Database Access features of OpenOffice.org? You can use odbc > or jdbc (I can only vouch for the latter, on Linux) to connect to the > mysql server from within OOo. "Should" work just fine on your

Re: Dumping MySQL result set to a spreadsheet

2004-02-29 Thread Neale Banks
On Sun, 29 Feb 2004, Joshua Beall wrote: > I am wondering if anyone can point me to a utility that will let me dump > the > result of a MySQL query to a file I can open in MS Excel or (preferably) > OpenOffice.org Calc. [...] > But before I spend any time working on doing that, I am wondering if >

Re: Dumping MySQL result set to a spreadsheet

2004-02-29 Thread Paul DuBois
At 17:45 -0500 2/29/04, Joshua Beall wrote: Hi All, I am wondering if anyone can point me to a utility that will let me dump the result of a MySQL query to a file I can open in MS Excel or (preferably) OpenOffice.org Calc. phpMyAdmin lets you do this if you want to dump a "SELECT * FROM ", but if