The Excel format is mostly proprietry and messy. If you just want to
do this a couple times, put your query results in a text file and then
try opening them in Excel. It'll ask about how they're delimited or
whatever. Just tell it that the columns can be split on a tab. Also
change all the field type within Excel to "text" instead of the default,
cuz it starts interpreting things as dates and such.
If you're going to be doing a lot of this, then you could look into
the ODBC stuff for Excel and Mysql. I've never done this part.
I think I may not have actually answered your question, but hope this
helps.
--Ben Kirkpatrick
On Tue, 15 Jun 1999, Roger Smith wrote:
> Hey guys does anyone know how to export a query from a database to an
> excel file or some kind of etxt format??
> Thanks,
> Rog
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5249@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>
