Download data from FTP to MS Access

[vlad]

Hello guys
I have one, maybe silly, question.
I have a lot of tables placed on FTP (txt, csv) and I need to download them ( or link) to my MS Access working file. I have no clue how can I manage it.


Can you please give me some hint?
Thanks

[ranman256]

Download the files to a folder to a generic name every time....like clients2import.txt.
link the text file as a table
build a query that appends the linked table to a perm table.
Put this qry in a macro.

so the workflow would be:
FTP the file
run the macro. Done.

[vlad]

Hi Ranman256
Thank you for you help, but I have one small problem, how can I manage to have same name for file from FTP. Ftp files have name+appendix contains date of posting e,g iScala7q -2015/10/12 next month the same file will be under iScala7q -2015/11/15. so I have no idea how can I hit same name for same file month to month
Thanks

[ssanfu]

If I understand correctly, you download via FTP text/csv files to a folder. Then you want to import the data in the files into access.

Method:

1)The code can open the "Open File Dialog Box" to allow you to select the file to import. If there are 5 files to be imported, you would have to execute this code 5 times.

2) The code can open the "Open Folder Dialog Box" to allow you to select the folder that the files are in. The code cycles through the files (all files that match the criteria) in the folder. The file names are not important in that the code will find every file that meets the specs. After importing, the files would need to be moved (via code or manually) to an archive folder. This clears the FTP folder to be ready for next months downloads.


I have used both methods.... both work very well.