At 12:14 07/22/1999 , Alan Novick wrote:
>I'm trying to export an AS/400 physical file to a comma separated
>variable file in a folder so I can email the data to someone who can
>open the file in Excel.  Right now I am doing it in two steps.
... SNIP...
>Is there an easier/better way to do this?

Since the desired end result is an Excel spreadsheet anyway, why not just
send one? That's what I usually do. The following procedure is pretty
close, but I don't have access to the current version of Excel or the
AS/400 at the moment, so this is from memory.

  1. In Excel, Open menu data | get external data | create a new query.
  2. Specify or create an appropriate ODBC datasource when prompted.
  3. open SQL view (or use the GUI query builder if you like)
  4. create a query like "SELECT * FROM MYFILE"
  5. File | Return data to Excel
  6. Back in Excel, File | Send To | Email recipient

Note this procedure does require that you are able to connect to your
AS/400 via ODBC. If you haven't already built a datasource, you can do so
as part of the process. Excel and MSQuery insists on using a "file"
datasource, so you may end up duplicating a system or user datasource name.
This doesn't seem to cause problems.

Pete Hall
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to
| To subscribe to this list send email to
| To unsubscribe from this list send email to
| Questions should be directed to the list owner/operator:

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].