I need a macro in Access that will do the following task;
1. Load multiple excel files into access table. All the files have the same format
2. Copy Excel files into backup folder
3. Delete excel files from source file in step 1
It should be developed in Access 2007, 2010 or 2013