I have a client that receives an Excel file via email about every 2 hours throughout the day. I've written a macro that copies that Excel file to a specific folder on the users network.
Now I need to open Access and run a make-table query that will create a table from several linked Excel files. What is the best method for doing this? I would like to do it from Outlook, maybe with an autoexec macro in the Access application, but need to know how to open the Access database.