Topic "VBA Exapmples"

Author Message
TimTPD
[View user's profile]

Joined: 2013-02-23
Posts: 2
I need to automate FTP from within an Access 2010 database.
I have spent a lot of time on this and have not found a 100% reliable solution.
My latest attempt can upload / download files but I have found that the downloaded files become corrupt. They are .csv files. If I download them using an FTP programme they are correct, but as soon as I use the vba solution I have they are corrupt. I can't figure it out and am very frustrated!
WinSCP has been recommended to me. However before jumping in, I would like to know (and get sample vba code) if I can automate the following from within Access 2010:
* get list of files on ftp server
* upload files to ftp server
* download files from ftp server
* rename files on ftp server
* delete files on ftp server

Many thanks in advance. Sample working code for the above will be most welcome and will automatically trigger a donation
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
You can do all these with WinSCP .NET assembly/COM library. Please see:
https://winscp.net/eng/docs/library_vb
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License