Linked Table via Excel w/ Data Connection to an XML File

[n9uns]

I have a linked table in a local Access (2010) database. This linked table contains a table that's connected to an XML file on the server. The reason why I have it set up this way is because from my understanding, Access does not have the ability to create a link to an XML file.

In any case, the XML file is a daily file that gets replaced every day. If I want to view data today (4/24/2019 from some XML file from say 4/15/2019, I wouldn't be able to view the data via the linked table that I created since the XML file that's driving the linked table is overwritten everyday; I'd have to go to the file location and open the XML file from 4/15/2019.

The daily files are saved on the server with a date suffix at the end of the file name.

Example:

Daily Filename: LiveFile.XML​

Historical Filename: LiveFile_190415.XML​

Is there a way to have the linked table look at a different XML file based on a date in an access form?

Example:
If I have a date of 4/15/2019 in some form in my local database, can I have the linked table which is currently setup to look at LiveFile.XML look at LiveFile_190415.XML as per the selected date?

Probably could explain better but struggling with this at the moment. Please feel free to tear this up and ask questions.

TIA

 

[stumac]

Not sure why this has been moved from the access forum as it an access question (albeit referencing an XML file).

Access doesn't really have a straight forward way of doing this, it would require VBA code, a couple of different ideas for that would be to re-link the table or overwrite the Livefile when the selected date is changed.

 

[xenou]

if you changed the file name of LiveFile_190415.XML to LiveFile.XML then it should work too, I guess. Assuming you can also change the current LiveFile.XML to LiveFile_XXXXXX.XML. There must be something like this happening already otherwise you wouldn't have all those historical records (either copying or renaming or moving of the current file each day).

I've never heard of Access connecting to an XML file but you should also be able to import an XML file.

You might also be able to just save your data yourself each day so you have your own backups of the daily files (possibly, then, just stored as regular Access data).