Have MS Visual Basic timers start and run MS Access (VB enabled) modules,
which do data queries and the results are contained within an auto
export *.xls file(s), which are futher given the instruction to be
placed upon a given Networked PC file server location/path (final
parking spot).  Question:  What additional instruction(s) and/or
software setting(s) are needed to allow the MS Access (VB enabled)
module to automatically export and successful push files to parking
spot path upon given FTP PC file server (which ID access to has been
established) instead of a Networked PC file server?

---

Clarification of Question by 1901bell-ga on 30 Jul 2004 09:22 PDT

Another member of our department found the answer...program called WebdriveŽ.
http://www.webdrive.com/index.php?pg=./products/webdrive/index
It allows you to map a drive letter to an ftp server.


But, we would like to thank "crythias-ga" for posting three comments
upon this question (they were good thoughts).

Thank You, 1901bell-ga

You could use built-in command prompt ftp. Not exactly pretty, but ...
create a temp script file composed as follows:
o ftp.remotesite.com
username
password
literal pasv (optional, but may help if you're behind a firewall)
bin
verb
prompt
put filename.ext
quit
-=-=-
drop it somewhere (c:\tmpscrpt.ftp)? then call it:
ftp -s:c:\tmpscrpt.ftp

I suppose there is some code in VB that can do it. Everyone has FTP
unless they manually remove it.

Oh, and delete the tmpscript after it's used :).

Oh, and you can add
cd remotedir\remotedir2\remotedir3 or
cd remotedir/remotedir2/remotedir3
before the "Put" line if it needs to be in a subdirectory.