I have the need to transfer a file to an ftp site using Access.



Here are the details: (The names are changed to protect the privacy of the site)

I write the file (called Import.dat) to "Z:\My Documents\ACImports" from an Access form.
I would like to call the code to transfer to the ftp site at the end of the existing form.

(I don't know what all of this is necessary, but this is what was supplied by the ftp vendor)
The host name is ftpserv.priv.com
The port number is 21
The path is C:ftp\ash\slto
The username is shaftp
The password is sha

Has anyone done something similar to this?

I am not very knowledgable with ftp sites, so please keep your response simple.