I use a PERL module called Spreadsheet::WriteExcel. You can get it from CPAN at http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/.
I generate tons of reports monthly using cron to fire off PERL scripts that output my data as Excel spreadsheets using this module. Implementation is fairly easy and the documentation that comes with the module is clearly written with tons of examples. Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705 -----Original Message----- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: export to csv or excel Hi, Do you know a good tool to export mysql tables to csv or excel files? It should be able to run on a Linux system, and should be able to be scheduled (cron job). I worked with EMS Mysql Export on a Windows system, this worked fine, but I can't get it to work on the Linux system. I also tried with "SELECT ... INTO OUTFILE ..." but this gives problems when there are "end-of-line" characters in the data. Thanks, Bart
