Question How to import data from an excel file stored on a website? (1 Viewer)

Hi!


I'd like to know if it is possible to import data to access as a linked table from an excel file, stored on a webpage (not in Sharepoint)?
This is the link to the file:
https://www.jazmp.si/fileadmin/datoteke/seznami/SFE/Prisotnost/Seznam_24_HUM_prenehanja_motnje.xls



When I try to import it, access gives an error, saying "Only XML files can be imported from an Internet address (http://, ftp://). Enter a path that points to a location on your computer or on the network"

Hi. I think you may have to download it first. Once you have linked to it on your computer, you can download the latest copy and overwrite the old one.

Thanks for the reply.

There is obviously no other way than a daily file downloading...