If you have Excell you can use the Get External Data to get the data from
MySQL using MyODBC.
Also you can use MSQuery to query the database and send the result to Excel.
Another way would be to write a macro that uses ADO and process the results
into the workbook.
HTH
JFernando
*** sql ***
---
at once
- sorry!)
Andrew,
Sql,query
-Original Message-
From: Andrew Braithwaite
Sent: Tue 29 October 2002 09:58
To: 'Ma, Billy'; [EMAIL PROTECTED]
Subject: RE: Query and export to a Excel file
Hi,
You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump
the
Hi,
You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump
the file into a tab delimited text file or cvs. You will be able to open it
in excel in those formats.
Alternatively (if you want to get a bit more involved) there is a perl
module you could use called Spreadsheet::Wr
