Connecting to an SFTP server via Access VBA?

[jimswork1341]

Hey everyone.

I was recently able to provide my department some VBA code (Access 2010) to connect to an FTP server and download / upload files, and do so via automation through Task Scheduler.

Apparently this has caused them to have some faith in me, and now I’ve been tasked with something that no one else has been able to do: write VBA code to connect to an SFTP server.

Do any of you Access geniuses have any experience with this? It doesn’t matter if it’s completed via a batch file, or straight through VBA… the only limitation I have is I’m almost surely not able to download any third-party programs to get this done, as the company is pretty stringent when it comes to downloading / installing any new software.

I’m hoping that someone here has done this before, and would have a good jumping off point for me. I’ve looked around the web, and I’m not finding anything too concrete as of yet.

Thanks everyone.

[NeoPa]

I believe SFTP is simply Secure File Transfer Protocol.

You could try checking your existing DLL first to see if it can handle SFTP servers.

If not then Windows has a built-in FTP client that may be able to do that for you. This is reasonably advanced stuff though, and I don't even have my old project to hand where I did some similar work. This will not be a solution, or even an approach, to go for unless you're up for some hard and complicated development. Just saying before we even consider that approach and commit man-hours of work to it.