Get File from FTP Server into Access

[one3nine0]

There is a file in a FTP server that I would like to download into MS Access 2010 to replace the old version of the file when I run the code/macro. We will call the table "PriceFile"

To get to the server I usually open a browser and enter "ftp://XX.XX.XXX.XXX", enter in user and pw, and then select the desired file to download to a folder on my computer.

I would rather have it download straight into Access so i don't have to go through the extra steps.

The file is usually YYYYMMDDPRICES.TXT, and I want to download the most recent one.

Is this doable in Access? I've seen other versions, but you need to type in the actual file name, where I just want to grab the most recent file.

 

[xenou]

1) strictly speaking you cannot download an ftp file "straight into access". But you can download a file to a local folder and then import the file into Access. So all you really need to do is automate or script the file transfer.

2) I don't know of an easy way to get a particular unknown but latest file that fits all situations. If the latest file is always todays file, than you can simply use todays date as your YYYYMMDD key. That is nearly always available in scripts and code as a kind of date() function.

 

[one3nine0]

Ok, I was hoping not to have to download the file before running the code or script to import it into access. No worries though. Thanks for the info

 

[Micron]

maybe either of these?
https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm

http://access.mvps.org/access/modules/mdl0037.htm

I see lots of stuff for Googled "ms access download file ftp" some of which is for uploading, some for proprietary software, but still lots that may fit the bill.