FTPs connection :: Support Forum

pascual14
Joined:: 2022-06-20
Posts:: 5
Location:: España

FTPs connection

2022-06-20 10:31

Hello, is it possible to create an FTPs connection to send and receive files and this can be automated from the access VBA code with WinSCP or PuTTY? Thank you

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 37,576
Location:: Prague, Czechia

Re: FTPs connection

2022-06-23

Please start here:
Automate file transfers (or synchronization) to FTP server or SFTP server

Reply with quote

pascual14

FTPs Connection

2022-06-23 08:11

Hello, but I don't need sFTP but with FTPs, which is different due to the security issue, since this is for Windows servers. If I'm not mistaken it's not the same. Thank you.

Reply with quote

martin◆ Site Admin

Re: FTPs Connection

2022-06-23

That does not matter, WinSCP supports all of them (FTP/FTPS/SFTP). The script would be mostly the same, you just pick the right protocol.

Reply with quote

pascual14

2022-06-23 09:30

Ok, I understand, and can it be integrated to send and receive from access with VBA? maybe with PuTTY? Thank you.

Reply with quote

martin◆ Site Admin

2022-06-27

Of course, VBA can run external programs.
I do not think PuTTY is relevant here.

Reply with quote

pascual14

FTPs connection

2022-08-03 18:09

Hello, I'm lost, and you don't have any example of VBA code to use WinSCP and connect to an FTPs server and send a file and receive? Thanks.

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 37,576
Location:: Prague, Czechia

Re: FTPs connection

2022-08-04

There are zillions of questions on vba+winscp on Stack Overflow.
For instance:

Reply with quote

pascual14

FTPs connection in vba access

2022-08-10 12:40

ok, and once I have the connection configured in WinSCP, can I export that session to a script to execute it from the vba command line? Right now I wouldn't know how to create that script with the configuration I have. Thank you

Reply with quote