Re: Automating Quary -> File -> Excel

Hi Bob,

We use Kemetech's CVTDBFXLS tool for creating spreadsheets from Physical
Files.

Create a CL program to:
1) Run the Query
2) Use CVTDBFXLS to create a spreadsheet, or use one of Scott
Klement's tools to create the spreadsheet
3) You can not 'Prettify' the spreadsheet automatically
4) We use the SNDM command to email the spreadsheet. I found this
free on the internet.

HTH.




Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



From: "Bob Voltz" <bob.voltz@xxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Date: 09/29/2010 01:08 PM
Subject: Automating Quary -> File -> Excel
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Once a month I do the following:

1. Run a query to create a file.

2. Import that file into Excel.

3. Prettify the spreadsheet.

4. Email the prettified spreadsheet to a user.

What is the best way to automate this process?