Hi,
I have a database of 5 tables that I have imported from 5 csv files. I have then run different queries to produce new tables of combined data, converted date formats and added a calculated field to one table.
I have then linked the new tables to Excel for analysis.
The csv files are updated periodically with new data being added (but the field headings remain the same).
This is where I am getting stuck...
When the csv files are updated what's the best way to import into Access then run the queries? Is it possible to do it automatically in some way or do I have to manually import each file then manually run each query?
If anyone could point me in the right direction I'd appreciate it.
Thanks
I have a database of 5 tables that I have imported from 5 csv files. I have then run different queries to produce new tables of combined data, converted date formats and added a calculated field to one table.
I have then linked the new tables to Excel for analysis.
The csv files are updated periodically with new data being added (but the field headings remain the same).
This is where I am getting stuck...
When the csv files are updated what's the best way to import into Access then run the queries? Is it possible to do it automatically in some way or do I have to manually import each file then manually run each query?
If anyone could point me in the right direction I'd appreciate it.
Thanks