Re: AS400 to PC transfer in EXCEL or ACCESS format

Synapse has an SQL based file transfer product available (WinTran) that
runs over either native SNA or over native TCP/IP.  WinTran is part of
their WinAPPC (SNA) and TCP/IP offerings.  It supports many format types
compatible with Excel and/or Access including comma delimited, tab
delimited, text, BIFF (Excel), DIF, dBase, etc.  I like dBase because the
data dictionary comes down with the data and so all of the columns in Excel
or Access have headings are are properly sized and typed.  dBase is a
common denominator format compatible with most database/spreadsheet
systems.  I don't pgm in dBase at all nor recommend it.  You can click on
the library, file, member, fields, etc. and click SQL restricts, sorts,
etc.  It is callable from VB and C++ with messaging as to transfer status.
A free, full running demo is at http://www.synapse.com.

Claimer:  I sell, support, recommend, and use Synapse products.

Jerry

At 01:35 AM 1/20/99 -0500, you wrote:
>Hi all,
>
>Could anybody give suggestion on transferring an AS400 Database File to
>PC in EXCEL or ACCESS format?
>Thanx in advance.
>
>Rgds,
>Shiva.


Jerry Draper, Trilobyte Software Systems, since 1976
Specializing in connecting PC's, Windows, MAC's, and LAN's to the AS/400
Representing Synapse, Apple, IBM, UDS, Nlynx, MI, DCI, Netsoft, etc.
(415) 457-3431; (415) 258-1658fax; jdraper@wco.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---