I have a static URL https://www.amfiindia.com/spages/NAVAll.txt in which all NAV will be updated on daily basis. What is the best way to import the same in Access without manual intervention like storing the data in a text file and importing it in access manually.

Could anyone help in ideas.

Thanks in advance

Raji V