FTP

[NG]

Hi,

At a point I export some data (text delimited) and create an Export.txt file
in my Access program. Now I need to transfer it automatically to the server
of the receiving company so they can pick it up and import the data in their
own application.
Is there any means of including the ftp command in my code, other then
starting a .bat file with the shell function?

 

[Stuart McCall]

Hi,

At a point I export some data (text delimited) and create an Export.txt
file
in my Access program. Now I need to transfer it automatically to the
server
of the receiving company so they can pick it up and import the data in
their
own application.
Is there any means of including the ftp command in my code, other then
starting a .bat file with the shell function?

Take a look at:

http://www.smccall.demon.co.uk/Downloads.htm#FTPClient

It's well commented so you ought to be able to figure it out easily.
The Form frmUpDownTest is the best place to start. Once you know which bits
you'll need, import the class module into your application and you're ready
to go.