I have been tasked with creating a daily report. I would like to automate the entire process, if possible. I'm talking about not touching it at all once it is set up! If guided, I am fairly comfortable using macros and VBA.
Here is my 1st question of 4 at this point:
I would like my Access database to automatically import an excel file to tbl1 as the file is published daily to a server folder. The file names are date based (Report100313.xls, Report100413.xls, etc).