FTP Scripts / Automation

[Joe Santacroce]

I have several FTP Batch Files (.BAT) and Scripts (.TXT)
that I use to update an Intranet site on a daily basis. In
the first level of automation I tried to automate these
scripts using the SHELL Command but it kicks off and does
nothing. The batch process is called, but doesn't run. I
tried a number of different things including adding a
delay while it runs but to no avail.

As a second and preferred alternative, I would like to
fully automate the FTP update in Access. This would also
allow to include a prompt for the user ID and password
instead of having to edit the script files to update the
ID and PW.

Ex:

..BAT

ftp -i -s:ftpscriptprod.txt > ftp.out

..TXT

open intranet.com
userid
password

cd /recon/current
lcd I:\Reconciliation\Current
mdel *.*
mput *.*
cd /dmd/prior
lcd I:\datamgmt\Reconciliation\Prior
mdel *.*
mput *.*
quit

--------------


Any suggestions would be appreciated.

Thanks,

Joe..