Re: Getting a PC File to the AS/400 via Client Access (Windows 95)

One thing I've done in the past when faced with this is to create a
physical file on the AS/400 with the fields the way you want them, and
use the Client Access/400 ODBC driver and Microsoft Access to upload the
records from the PC to the file.  Create an ODBC data source that points
to the file (using the Client Access ODBC Administrator), and then link
the AS/400 to an Access database on the PC.  Import the text file to
another Access table in the same database, and then write a query to
append the records from the text file to the AS/400 linked table.  Make
sure there are no null fields in the text file.  This can run very slow
(ODBC), but for a one-shot deal, works pretty well.

Chuck Lewis wrote:
> 
> Hi Folks !
> 
> I am TRYING to get a file from a PC to the AS/400...
> 
> We are on a 620, V4R1
> Windows 95
> Client Access
> Net Soft Router
> TWIN-AX (BOS) emulation card
> NO network (yet...)
> 
> File is from a Unix system via a custom written utility that produces an
> ASCII text file, "columnar" layout, no delimeters...
> 
> WHAT is the easiet way to do this ?
> 
> Thanks !!
> 
> Chuck
> 
> +---
> | 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
> +---

-- 
Brian D. Stark, CCP
Atlantic Computer Associates LLC
bstark@atlanticassoc.com
starkb@ctc.net
+---
| 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
+---