I import 2 CSV files into MS Access and then apply some not complex queries based on content of both files to obtain a result table.

I've seen that the import/export steps can be saved, but is there a way to save the queries and get automatically the result table each time the input files change? Similar to what can be done in power query.

CodePudding user response：

There are several ways to deal with importing volatile data sources but I will suggest what is probably simplest.

If file structure remains same, overwrite old files with new files (use same generic names). Set links to files (one time). Queries do not have to be modified because source names and structures never change.

Build code (macro or VBA) behind a form using a command button Click event to initiate whatever process is needed to manipulate data in linked tables. This could be calling UPDATE or INSERT action SQL or simply opening form or report.