FTP from Access

[Nigel Bennett]

I would like to FTP a file from within access, I create a
file in a folder on the c drive (orders) and call it bob

I would like to be able to use ftp to send the file to a
company

in a table I have the ftp website address 1.1.1.1:23
username user
password Fred

what is the syntax to add the file to the ftp command and
then send it automatically

something like
ftp://1.1.1.1:23 "c:\orders\bob.txt",user,fred

Any assistance would be appreciated

 

[Alex Dybenko]

Look at these 2 pages:
http://www.mvps.org/access/modules/mdl0015.htm
http://www.mvps.org/access/modules/mdl0037.htm

 

[Brian]

I would like to FTP a file from within access, I create a
file in a folder on the c drive (orders) and call it bob

I would like to be able to use ftp to send the file to a
company

in a table I have the ftp website address 1.1.1.1:23
username user
password Fred

what is the syntax to add the file to the ftp command and
then send it automatically

something like
ftp://1.1.1.1:23 "c:\orders\bob.txt",user,fred

Any assistance would be appreciated

Not that simple, I'm afraid. The Internet Transfer Control works OK, if you
can bear to use an ActiveX control. Or, you could take a look at this:

http://www.mvps.org/access/modules/mdl0037.htm