Need help with Secure FTP

[Tazcat]

Hi everyone,
I've already pulled 1DMF's wonderful code on FTPing files with Access (particularly liked the error handling routines, btw). But my problem is this: my company requires that we use SECURE FTP (SFTP) rathter than plain FTP. I've been searching all over the place, but cannot find any refereneces to the WININT API library methods for SFTP. I would be most greatful to anyone who can point me at some resources for creating SFTP connections, or who might suggest how to modify 1DMF's existing API code to open an SFTP connection.

Melanie
~Tazcat2k~

 

[jrbarnett]

FileZilla can do secure FTP and be scripted.

This gives an idea of how to script out an upload via sftp:

http://forum.filezilla-project.org/viewtopic.php?f=2&t=5660

You need to create the batch file then run it from Access with the Shell command.

John