You can easily accomplish that by dumpin into a CSV (comma separated file)
with .csv extension which will open in excel as you want.
Ilya
-----Original Message-----
From: NIPP, SCOTT V (SBCSI)
To: '[EMAIL PROTECTED]'
Sent: 10/1/02 9:04 AM
Subject: Database to Excel script...
I have a MySQL database that I have a few Perl scripts working
on.
I am now looking into doing some reporting on these database tables. I
would really like to find a script that queries the database and the
uses
the Spreadsheet::WriteExcel module to output the data directly to an
Excel
file. Does anyone out there have something like this that I could
cannibalize? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
