C.R.Vegelin wrote:
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE 'D:
a real header-line ?
TIA, Cor
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, December 10, 2005 5:17 PM
Subject: RE: from MySQL to MS Excel ...
There is at least one other option that JR didn't mention... at least some
versions o
There is at least one other option that JR didn't mention... at least some
versions of Excel have the menu option Data->Get External Data which
allows you to link through ODBC to run queries directly from within Excel.
I have barely used it and I have never tried it with MySQL so I can't
really
Here's the skinny -- YES and NO.
NO in that it won't export directly, YES in that you have to do a little leg
work in order for it to be done.
You have 3 options -- ODBC, Code and CSV.
ODBC -- Excel has the ability to use ODBC connections to the MySQL database.
Run your MySQL query with the H
