Export Text to FTP Site

[Guest]

Does anyone know if Access VB code can be used to export a CSV file to an
anonomously secured FTP Site?

I've tried using the TransferText method, but get "Run-time error '3011':"
The Microsoft Jet database engine could not find the object
'ftp://Usernameassword@IPAdress/Path/filename.txt'.

Thanks,

VBADabbler

 

[Douglas J. Steele]

Access doesn't recognize the FTP protocol (nor the HTTP protocol, for that
matter). You cannot use a URL in the TransferText method.

Write the file to the hard drive, then transfer it to the server. There's a
simplistic approach shown in http://www.mvps.org/access/modules/mdl0015.htm
at "The Access Web", or a more sophisticated add-in at
http://www.mvps.org/access/modules/mdl0037.htm (you'll need to convert the
add-in to whatever version of Access you're using, or you can just copy the
code from within it)

 

[Guest]

Douglas,
Thanks so much for your reply - I suspected as much.

Many thanks too for the pointers to the alternate methods - I'll give them a
try.

Regards,
VBADabbler

 

[Guest]

Doug,
I've followed your advice below in downloading and implementing the add-in
at the second link. It works like a charm on anonymous authentications
uploading. However, I need to download files also by anonymous
authentication, but can't seem to get the add-in to work -- there is no
example for downloading other than from an unsecured ftp site.

Do you have any suggestions?

Regards,

 

[Douglas J. Steele]

There are supposed to UserName and Password properties associated with the
control.

See
http://msdn.microsoft.com/library/en-us/inet98/html/vbobjInternetControl.asp
for details.