FTP via MS Access. Get .bak files from an FTP server using MS Access VBA and convert them to .csv
The .bak files are on an FTP server. The goal is to download these files to a local directory and convert them to .csv files that can be imported in our system.
The names of the downloaded files should be stored in a local table to avoid downloading files twice.
The VBA code should be a function that we could call from elsewhere in the code.