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.
1) 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).
2) Upon successful import, I would like a cross-tab query I have built to run and export out to an email distribution automatically. Sidenote: Is there a way to make the crosstab query include subtotals for each row and column?
4) Upon successful distribution, I would like the records in tbl1 to be deleted automatically in order to keep a clean database ready to go for the next day's report.