Re: ODBC without CA

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

This can be automated in batch files on the PC. You use a script file with
the ftp statements you will use. The batch file can even build the script
on the fly, based on parameters passed to it.

But this does not pull a file directly into Excel. Is this what you need?

Do you need to update the 400 file from Excel? Again, ODBC with MS Query is
the easiest way.

FTP can be used. You download the file, process it in Excel, then upload
it. Lots of VBA work involved.

As leif says, there's a lot of info on FTP out there. It's part of TCP/IP.
Contact me off list if you want to here more. But I recommend one of the
ODBC drivers for simplicity. Cost seems to be around $125 per PC using it
(and down with quantiy purchase).

At 07:24 PM 4/12/02 -0500, you wrote:
>From: Rick Rayburn <the400man@hotmail.com>
>
> > How is FTP initiated?
> >
>
>to send file from PC to AS/400:
>go to a DOS session (start, run, command)
>FTP as400name
>
>it then asks you for user id and password.
>to select library of as400:
>cd library
>to send a file
>put pcfile as400file
>
>to exit:
>quit
>
>etc,
>but better go dig up some documentation about FTP.
>There are tons of that out there.
>
>try http://www.google.com
>search for FTP
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.