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
ODBC connection above for another option using the HTML
flag.
>
> HTH,
> J.R.
>
> -Original Message-
> From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 10, 2005 9:35 AM
> To: mysql@lists.mysql.com
> Subject: from MySQL to MS Excel ...
&g
: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 10, 2005 9:35 AM
To: mysql@lists.mysql.com
Subject: from MySQL to MS Excel ...
Hi Friends,
I am looking for an easy and seamless way to export MySQL query output to MS
Excel.
At this moment I am using MS Access 2003 as front-end for a M
