Using a web interface I export bank transactions into a csv file - the name of this file is always the same.
I have an access table that is linked to this csv file. I then query this table and do things.
Can the linked table be refreshed without opening it?
Or do I just run some code that opens and immediately closes the linked table?
Do I need to delay closing of the file in this scenario so that it has time to refresh?
thanks
I have an access table that is linked to this csv file. I then query this table and do things.
Can the linked table be refreshed without opening it?
Or do I just run some code that opens and immediately closes the linked table?
Do I need to delay closing of the file in this scenario so that it has time to refresh?
thanks