I'm sure that this has been covered ad nauseaum but please humor me.
I'm essentially trying to:
1. Import XLS1 into existing tbl1 in Access
2. Import XLS2 into existing tbl2 in Access
3. Run existing query1 in Access
4. Export query1 results in XLS format
5. Empty the contents of tbl1 and tbl2
The kicker is that I'd like to prompt users to browse for the file path of XLS1, XLS2, and the destination of query1 results.
Any advice or pointers for a beginner?