How to Automate tasks to generate reports

[WillyBootstrap]

I'm new to MS Access. Please somebody help me on how to automate an import and export task to generate a report.
I have a number of files with the same structure to generate a report.
And these files keep on changing every month.

I've searched other forums but found this one more appropriate.
can Macros be of any help? if yes then please provide any links to good tutorials

Edit:
I have a few csv files which need to be imported into a single table. and after performing some SQL queries the result is to be exported into another csv file.
I can do these tasks manually through Access but it needs to be automated...as in on a click of a button, yes David.
After some research on the internet it seems macros may be useful, but thats the problem. How to use macros?

 

[EternalMyrtle]

You need to try to rephrase your question as nobody can understand it as it is currently written (this is why you don't have any responses).

What are these "tasks" and "files" (as you call them)? What format are they in? Do you have a database? Are the file in your tables?

 

[David R]

Also what are your conditions for automation? Do you need it to run at 4am so it's on someone's desk when they arrive in the morning, or do you mean a button to run several reports in succession?

 

[David R]

Are the filenames predictable (hopefully generated by a computer or a competent admin), or would one be SeptSaleReport.csv and one OctoberSales2013.csv and the next 20131101Sales.csv??

If you can give us the pattern/scope of the stuff you're importing we can help you write code to do all of this behind a single button (probably, if the filenames are predictable). Macros would work but they're harder to debug, less flexible, and not as powerful.

Based on your original post it sounds like all of the queries you need to use are already written. We'll need those names too, and what order you run them in of course.

 

[WillyBootstrap]

The filenames are not predictable. But they all have the same structure and all are csv's. They are system generated and their exact number is also unknown.
So instead of filenames we'll probably have to use *.csv
The procedure is to be run twice every month.

Actually I'm not able to get a headstart

 

[David R]

What are some sample filenames? I'm having a hard time with "not predictable" but "system generated"...

If you don't know the exact number, what determines how many you run? Timeframe?