Hi All. I am hoping someone here can help me.
I have an external text file that is updated every 15 minutes from an Oracle database. I would like this file imported into an Access database table, but I would like the table refreshed every 30 or so minutes so that any changes made to the text file will eventually show up in the table.
I know that there is a link-to-data-source option, but it seems like that holds up whatever text file you are trying to link to in that the file cannot be modified while the access file is open and referring to it. Being that the text file that I will be linking to is updated every 15 minutes from an Oracle database, that would present a problem.
Is there any way to refresh imported data at a specified interval of time in Access? Microsoft Excel has this function so I figured that this would be easy to do in Access as well. I am new to Access and still trying to figure things out.
Thanks in advance,
Anthony