Yes. I also am using phpMyAdmin for some queries, but I am actually
looking to create a cron job that will run a monthly report and e-mail the
resulting Excel file to a couple of individuals. I am able to do all of
this manually at this time, but I would really like to automate the process
if possible. This is also a great learning opportunity and I think that I
will have more requests in the future for generating Excel reports of this
nature.
-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 10:11 AM
To: NIPP, SCOTT V (SBCSI); ''[EMAIL PROTECTED]' '
Subject: RE: Database to Excel script...
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 <http:\\ldsa.sbcld.sbc.com>
